Annoying #1064 Error
Posted: Sun Dec 28, 2003 11:24 pm
I always get an error like this and its buggin me cuz i dont know what wrong. Please help me.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