adding multiple columns in one ALTER statement

Panoy · #1 (**permalink**) 03-28-07, 16:41

Hi to all,

Is is possible to add 4 or more columns in one ALTER TABLE statement in mySQL? So that I can save a lot of typing, so far I could not figure it out. What I am trying to do is create each ALTER TABLE statement for each new column that I am trying to add.

Thanks and god bless.

r937 · #2 (**permalink**) 03-28-07, 17:54

Code:

ALTER TABLE daTable
ADD COLUMN foo INTEGER
ADD COLUMN bar INTEGER
ADD COLUMN qux INTEGER

Panoy · #3 (**permalink**) 03-28-07, 18:01

hey thanks, but your statement lacks a comma.

I have found out that it should be like this:

Code:

ALTER TABLE tblName 
ADD COLUMN col1 date,
ADD COLUMN col2 date,
ADD COLUMN col3 date;

r937 · #4 (**permalink**) 03-28-07, 18:18

................

Internet Services

Web Development

Digital Marketing

Consumer Tech