[thelist] sql, adding a field problem in phpMyAdmin

Tom Dell'Aringa pixelmech at yahoo.com
Thu Nov 14 13:52:00 CST 2002


--- rudy <r937 at interlog.com> wrote:
> > You have an error in your SQL syntax near 'NOT NULL' at line 1
> >
> > ALTER TABLE `menuitem` ADD `menuItem` VARCHAR NOT NULL
>

> might be the missing size on VARCHAR

BINGO! Thank you Rudy! I'm still new at mySQL didn't know you had to
spec a size.

Tom

=====
var me = tom.pixelmech.webDeveloper();

http://www.pixelmech.com/
http://www.maccaws.com/
[Making A Commercial Case for Adopting Web Standards]

__________________________________________________
Do you Yahoo!?
Yahoo! Web Hosting - Let the expert host your site
http://webhosting.yahoo.com



More information about the thelist mailing list