Showing posts with label Mysql DELETE Column. Show all posts
Showing posts with label Mysql DELETE Column. Show all posts

Wednesday, 24 October 2018

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'