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.
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