limited time offer

How can you add and remove any column of a table in MySQL?

The syntax for adding any column in an existing table is shown below:

ALTER TABLE table_name ADD COLUMN column_name column_definition [FIRST|AFTER existing_column]

The syntax for removing any column from an existing table is shown below:

ALTER TABLE table_name DROP COLUMN column_name;