[thelist] sql, adding a field problem in phpMyAdmin

rudy r937 at interlog.com
Thu Nov 14 13:45:14 CST 2002


> You have an error in your SQL syntax near 'NOT NULL' at line 1
>
> ALTER TABLE `menuitem` ADD `menuItem` VARCHAR NOT NULL

can't be the backticks, those are okay

can't be the NOT NULL, that's pretty standard

might be the missing size on VARCHAR

might be that the table and column names are the same


rudy




More information about the thelist mailing list