How to delete a field in the table in mysql

Mysql method to delete a field in the table: You can delete a field in the table by executing the [alter table table name drop column field name;] statement.

Requirement:

Delete a specific field in the established table.

(Recommended tutorial: mysql video tutorial)

SQL command:

alter table 表名 drop column 字段名；

Related recommendations : mysql tutorial

The above is the detailed content of How to delete a field in the table in mysql. For more information, please follow other related articles on the PHP Chinese website!