Add Multiple MySQL Columns in One Query

1 year ago
Sophia Anderson
1 minute

In MySQL, you can use the ALTER TABLE statement to add multiple fields at once. Here is an example:

ALTER TABLE table_name
ADD column_name1 data_type,
ADD column_name2 data_type,
ADD column_name3 data_type;

In the example above, replace the table_name with the name of the table you want to add fields to, then list the field names and data types to add after the ADD keyword. Multiple fields can be added at once, separated by commas.

Please make sure to back up your data before executing the ALTER TABLE statement to prevent any unexpected issues.

bannerAds