mysql 中的删除列_如何从MySQL中的表中删除列

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?

解决方案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.