adding column problem.

[Anon]

Hello,

I need to add multiple columns to a table. Do I need to do 1 query per new column?

When I do something like this:

ALTER TABLE mytable ADD
newcol1 VARCHAR(200) default NULL,
newcol2 INT(1) NOT NULL default '1',
newcol3 date default NULL,
newcol4 VARCHAR(100) default NULL;

I get errors, but if I do:
ALTER TABLE mytable ADD
newcol1 VARCHAR(200) default NULL;
ALTER TABLE user ADD
newcol2 INT(1) NOT NULL default '1';
etc...

It works fine.

Help please

THANKS!

[siwis]

Your SQL is wrong:

Try:
ALTER TABLE mytable
ADD newcol1 VARCHAR(200) null ,
ADD newcol2 INT(1) not null default '1',
ADD newcol3 date null,
ADD newcol4 VARCHAR(100) null;

[Anon]

You know. I was looking at it and saying to myself that something was missing.

Kind of an important something 🙂

THANKS A TON!