How to delete a column from a table in MySQL

Question

Given the table created using    CREATE TABLE tbl Country     CountryId INT NOT NULL AUTO INCREMENT    IsDeleted bit    PRIMARY KEY  CountryId       How can I delete the column IsDeleted

User · Answer

You can use  alter table  lt tblname gt  drop column  lt colname gt

User · Answer

ALTER TABLE tbl Country DROP COLUMN IsDeleted    Here s a working example   Note that the COLUMN keyword is optional  as MySQL will accept just DROP IsDeleted  Also  to drop multiple columns  you have to separate them by commas and include the DROP for each one   ALTER TABLE tbl Country   DROP COLUMN IsDeleted    DROP COLUMN CountryName    This allows you to DROP  ADD and ALTER multiple columns on the same table in the one statement  From the MySQL reference manual      You can issue multiple ADD  ALTER  DROP  and CHANGE clauses in a single ALTER TABLE statement  separated by commas  This is a MySQL extension to standard SQL  which permits only one of each clause per ALTER TABLE statement

User · Answer

To delete column use this   ALTER TABLE  tbl Country  DROP  your col

User · Answer

If you are running MySQL 5 6 onwards  you can make this operation online  allowing other sessions to read and write to your table while the operation is been performed   ALTER TABLE tbl Country DROP COLUMN IsDeleted  ALGORITHM INPLACE  LOCK NONE

User · Answer

ALTER TABLE tbl Country DROP columnName

User · Answer

It is worth mentioning that MySQL 8 0 23 and above supports Invisible Columns CREATE TABLE tbl Country    CountryId INT NOT NULL AUTO INCREMENT    IsDeleted bit    PRIMARY KEY  CountryId       INSERT INTO tbl Country VALUES  1  1    2 0    ALTER TABLE tbl Country ALTER COLUMN IsDeleted SET INVISIBLE   SELECT   FROM tbl Country  CountryId 1 2  ALTER TABLE tbl Country DROP COLUMN IsDeleted   db lt  gt fiddle demo It may be useful in scenarios when there is need to  quot hide quot  a column for a time being before it could be safely dropped like reworking corresponding application reports etc

User · Answer

ALTER TABLE  tablename  DROP  columnname     Or   ALTER TABLE  tablename  DROP COLUMN  columnname

User · Answer

Use ALTER   ALTER TABLE  tbl Country  DROP COLUMN  column name

User · Answer

Use ALTER TABLE with DROP COLUMN to drop a column from a table  and CHANGE or MODIFY to change a column   ALTER TABLE tbl Country DROP COLUMN IsDeleted  ALTER TABLE tbl Country MODIFY IsDeleted tinyint 1  NOT NULL  ALTER TABLE tbl Country CHANGE IsDeleted IsDeleted tinyint 1  NOT NULL

[mysql] How to delete a column from a table in MySQL

Examples related to mysql

Examples related to ddl

Examples related to alter-table