alter table, adding multiple columns question

[lottos]

Schema on a table has changed between versions of an application I use.

I'm planning on migrating the existing table (member table as is, data and schema) and then wish to add the new columns after an existing column (eg password) and am wondering do I have to add each column at a time with multiple sql statements or can I add them all in one sql?
If in one sql, how please!?

Additional columns:

invisible set('1','0') default '0',
pmfolders text NOT NULL,
saveogpm char(3) NOT NULL default '',
emailonpm char(3) NOT NULL default '',
useoldpm char(3) NOT NULL default '',
webcam varchar(75) default NULL,

[nemonoman]

You add them all at once:
ALTER TABLE blank
ADD something columndefinition,
ADD somethingelse columndefinition,
ADD lastthing columndefinition;

columndefinition means like:
VARCHAR 30 NOT NULL

etc.;

[lottos]

Originally posted by nemonoman
You add them all at once:
ALTER TABLE blank
ADD something columndefinition,
ADD somethingelse columndefinition,
ADD lastthing columndefinition;

columndefinition means like:
VARCHAR 30 NOT NULL


etc.;

ALTER TABLE blank
ADD something columndefinition,
ADD somethingelse columndefinition,
ADD lastthing columndefinition;

AFTER existing columnname

?

[nemonoman]

Please RTFM:

http://dev.mysql.com/doc/mysql/en/alter-table.html

[lottos]

exactly why I asked the question in the first place as the reference seems unclear/illogical

alter_specification:
ADD [COLUMN] column_definition [FIRST | AFTER col_name ]

It doesn't state whether you can add multiple columns in one go... just like my question asked!

[nemonoman]

Please read my first answer; you can.

ALTER TABLE idontpayattention
ADD invisible set('1','0') default '0',
ADD pmfolders text NOT NULL,
ADD saveogpm char(3) NOT NULL default '',
ADDemailonpm char(3) NOT NULL default '',
ADD useoldpm char(3) NOT NULL default '',
ADD webcam varchar(75) default NULL

FIRST and AFTER would be additional attributes of a column

ALTER TABLE forumettiquette
ADD alittleappreciation char(15) NOT NULL default 'would be nice' AFTER gettingadvice,
ADD apoliteresponse char(15) NOT NULL default 'goes a long way' FIRST

[lottos]

🙂

thanks, I do appreciate your help, sorry if my 'tone' seemed off!

[lottos]

unfortunately it placed the 'webcam' column after the pwdate (correct) but the rest were added to the end of the column list

I was hoping for

pwdate
invisible
pmfolders
saveogpm
emailonpm
useoldom
webcam
existing columns

but got

pwdate
webcam
existing columns
invisible
pmfolders
saveogpm
emailonpm
useoldom
webcam