Page 1 of 1

Annoying #1064 Error

Posted: Sun Dec 28, 2003 11:24 pm
by Dale
CREATE TABLE `df_users` (

`id` INT( 5 ) NOT NULL AUTO_INCREMENT ,
`username` VARCHAR( 50 ) NOT NULL ,
`password` VARCHAR( 50 ) NOT NULL ,
`email` VARCHAR( 50 ) NOT NULL ,
`web` VARCHAR( 50 ) NOT NULL ,
`bio` LONGTEXT( 500 ) NOT NULL ,
`regdate` DATE( 10 ) NOT NULL ,
PRIMARY KEY ( `id` )
)

MySQL said:


#1064 - You have an error in your SQL syntax near '(500) NOT NULL, `regdate` DATE(10) NOT NULL, PRIMARY KEY (`id`))' at line 1
I always get an error like this and its buggin me cuz i dont know what wrong. Please help me.

Posted: Sun Dec 28, 2003 11:47 pm
by Weirdan
*text fields are not supposed to have any predefined length.

Posted: Sun Dec 28, 2003 11:49 pm
by Dale
oh... silly me :)

Thank You