How to Drop a Column in MySQL
Dropping a column in MySQL involves using the ALTER TABLE command. The typical syntax is as follows:
ALTER TABLE table_name DROP COLUMN column_name;
--The COLUMN keyword is actually optional
ALTER TABLE table_name DROP column_name;