adding multiple fields in one query

[cabernet]

I cannot figure the correct syntax to add many fields in an existing table; in one shot

from PHP MyAdmin

alter table xxxx add foo varchar 50 not null, foo_2 text not null; etc....

thanks

regards

 

[sleipnir214]

According to the MySQL online manual (

http://www.mysql.com/doc/en/ALTER_TABLE.html),

it should be

ALTER TABLE foo ADD (foo varchar(10) not null, bar int, fubar decimal(6,2))

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[cabernet]

thanks much for the correct syntax

I went before posting to the "MySQL alter table"
it does not mention anything about alter table

hmmm, I ewar glasses did read it twice; where is it?

 

[sleipnir214]

I don't understand your question.

But if the gist of your question was, "How did you find that information in the MySQL online manual?", then the answer is that I went to

http://www.mysql.com/doc/en

and entered "alter table" in the manual lookup entry field on the left-hand side of the screen.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[tarn]

Yes Cabernet, you glasses must have been steamed up at the time ...... see:

http://www.mysql.com/doc/en/ALTER_TABLE.html

This part:

alter_specification:
ADD [COLUMN] create_definition [FIRST | AFTER column_name ]
| ADD [COLUMN] (create_definition, create_definition,...)
| ADD INDEX [index_name] (index_col_name,...)
| ADD PRIMARY KEY (index_col_name,..............

Where (create_definition = foo_varchar(10) not null, create_definition = bar_int, ........)

Laurie.

 

[tarn]

Sorry:

Where (create_definition = foo varchar(10) not null, create_definition = bar int, ........)


!:¬o

L.

 

[cabernet]

Hello Laurie

thanks
I figured I was wearing sun glasses

Henry