Code: Select all
CREATE TABLE `rants` (
`id` INT( 4 ) NOT NULL AUTO_INCREMENT ,
`author` VARCHAR( 25 ) NOT NULL ,
`date` VARCHAR( 10 ) NOT NULL ,
`title` TINYTEXT( 100 ) NOT NULL ,
`rant` TEXT( 15000 ) NOT NULL ,
`visits` INT( 8 ) NOT NULL ,
INDEX ( `id` )
)MySQL said:
You have an error in your SQL syntax near '(100) NOT NULL, `rant` TEXT(15000) NOT NULL, `visits` INT(8) NOT NULL, INDEX (`i' at line 1
thanks.