How to Drop a column from the table in MySQL?

DROP column in table

Syntax:

ALTER TABLE table_name
DROP COLUMN column_name;

Let’s take an example to drop the column name “cus_address” from the table “cus_tbl”.

Use the following query to do this:

ALTER TABLE cus_tbl
DROP COLUMN cus_address;

Output:

mysql alter table 7

See the table structure:

mysql alter table 8