How to drop/delete a column in an existing table in MySQL database?

We can use ALTER TABLE statement to drop/delete a column in an existing table.

Syntax:

ALTER TABLE <table_name> DROP COLUMN <column_name>;

Example:

// Create table
CREATE TABLE employees (
    id int,
    first_name varchar(255),
    last_name varchar(255),
    email varchar(255),
    City varchar(255),
    state varchar(255),
    country varchar(255),
    zip_code varchar(10)
);


// Alter table to drop zip_code column
ALTER TABLE employees DROP COLUMN zip_code;