In this tutorial, we will learn how to drop a column in MySQL. Alter the table and drop the column look at the following example.


Example:

ALTER TABLE table_name DROP COLUMN column_name;


Drop multiple column

ALTER TABLE table_name
DROP COLUMN column_name_1,
DROP COLUMN column_name_2,
...;


I hope this will help you to drop one or multiple columns from the table.



Are you facing problems in understanding this article?
You can watch the video. Watch it now