Delete a column from an existing MySQL table

The SQL command in this recipe removes a column and the column’s data from an existing MySQL table.

To delete the column col_stuff from the table table_things, use the following SQL command:

ALTER TABLE 'table_things' DROP 'col_stuff'