Add new field to multiple table at once?

Question

I want to add same field to multiple tables. Can I do this with single query in MySql?

Thanks...

Answer 1

I don't think you can do this with a single query, as it requires the ALTER TABLE syntax which only supports one table per query (although you could add/modify multiple columns in the same table).

You have to do one ALTER TABLE query per table to be modified.