...

View Full Version : Create table error



LaundroMat
11-05-2002, 08:23 PM
What went wrong here?

Error

SQL-query :

CREATE TABLE `Nieuws` (
`ID` ENUM NOT NULL ,
`Submitter` INT NOT NULL ,
`_Time` TIME NOT NULL ,
`_Date` DATE NOT NULL ,
`Title` TEXT NOT NULL ,
`Content` VARCHAR NOT NULL ,
PRIMARY KEY ( `ID` ) ,
FULLTEXT (
`Content`
)
)

MySQL said:

You have an error in your SQL syntax near 'NOT NULL, `Submitter` INT NOT NULL, `_Time` TIME NOT NULL, `_Date` DATE NOT NULL' at line 1

mordred
11-05-2002, 09:31 PM
ENUM needs the possible values specified (like ENUM('foo', 'bar')), and VARCHAR needs the length specfied (like VARCHAR(23) ).

LaundroMat
11-05-2002, 09:38 PM
:thumbsup:



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum