How can multiple fields be added to a table in MySQL using the ALTER TABLE command?

2 years ago

Olivia Parker

1 minute

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

ALTER TABLE table_name
ADD column1 INT,
ADD column2 VARCHAR(50),
ADD column3 DATE;

In this example, we are using the ALTER TABLE statement to add three new fields to the table: column1 (integer type), column2 (string type, length of 50), and column3 (date type).

You can also add more fields as needed by simply listing out the new field information after the ADD keyword.