In order to add a new column into an existing table, we use the ALTER TABLE statement. This statement is not only used to add columns but also to delete and modify columns in an existing table.
CALTER TABLE table_name
ADD COLUMN column_name data_type;
By default, MySQL adds a new column at the end of the table. In order to add a column in the middle of the table, the following query can be used.
ALTER TABLE table_name
ADD COLUMN column_name column_definition [FIRST|AFTER existing_column];
Commonly asked MySQL Interview Questions