Error in syntax
Posted: Tue Mar 27, 2007 11:19 am
I just tried creating a table in phpMyAdmin and it executed the following SQL:
However, it is returning the error:
Code: Select all
CREATE TABLE `pireps` (
`piid` INT( 5 ) NOT NULL AUTO_INCREMENT ,
`pid` INT( 5 ) NOT NULL ,
`fid` INT( 5 ) NOT NULL ,
`hrs` DOUBLE( 5 ) NOT NULL ,
`comments` TEXT( 5000 ) NOT NULL ,
`filed` TIMESTAMP( 12 ) NOT NULL ,
`marked` TIMESTAMP( 12 ) NOT NULL ,
`status` TINYINT( 3 ) NOT NULL ,
PRIMARY KEY ( `piid` ) ,
INDEX ( `pid` )
)
Whats the problem?#1064 - You have an error in your SQL syntax near ') NOT NULL, `comments` TEXT(5000) NOT NULL, `filed` TIMESTAMP(12) NOT NULL, `mar' at line 1