Sometimes you will need to update the design of a table in MySQL. Below are the examples of adding and removing a column to/from a MySQL table.

To add a column to a table in MySQL:

ALTER TABLE `TABLE_NAME`
ADD COLUMN `COLUMN_NAME` ENUM('1','0') NOT NULL DEFAULT '1';

To remove a column from a table in MySQL:

ALTER TABLE `TABLE_NAME`
DROP COLUMN `COLUMN_NAME`;