[thelist] sql, adding a field problem in phpMyAdmin

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


--- Tony Crockford <tonyc at boldfish.co.uk> wrote:
>
> > I'm simply trying to add a field to my table in phpMyAdmin. I
> click
> > on "add new field" at "end of table". All I am doing is speccing
> the
> > name of the field as "menuItem" setting the null field to null
> (tried
> > not null, still errors) and leaving the selection to the right as
> > ---. I keep getting this error:
> >
> > Error
> > SQL-query :
> >
> > ALTER TABLE `menuitem` ADD `menuItem` VARCHAR NOT NULL
> >
> > MySQL said:
> >
> > You have an error in your SQL syntax near 'NOT NULL' at line 1
> >
> > This seems to be an awfully simple entry, what am I doing wrong?
> Am I
> > leaving out something
>
>  try menu_item and see what you get?

Same thing:

SQL-query :
ALTER TABLE `menuitem` ADD `menu_item` VARCHAR

MySQL said:
You have an error in your SQL syntax near '' at line 1

I tried the same exact line above in the command line and it also
errors out..

T

=====
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