Help with sql statement ALTER TABLE?

Question

Is it possible to add more than one column at a time using the ALTER TABLE command? For example:

ALTER TABLE employees ADD userid varchar2(50)

But lets say you want to add two or more columns, can you do something like this?

ALTER TABLE employees ADD userid varchar2(50), lastname varchar2(5), firstname varchar2(50)

etc.

Answer 1

You can do it, but like this



ALTER TABLE employees

ADD userid varchar2(50) ,

ADD astname varchar2(5),

ADD firstname varchar2(50)



If you are using MySQL, I suggest that you use phpMyAdmin to add, edit or erase is very easy to use

Answer 2

You use multiple ADDs separated by commas...

ALTER TABLE foo ADD userid varchar(50), ADD lastname varchar(5), ADD firstname varchar(50);

Answer 3

complex stuff. seek from bing and yahoo. just that could actually help!