How to delete table fields by mysql

This article will explain in detail how to delete table fields in mysql. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

To delete a table field is to remove a field from the table, which can be done using the "ALTER TABLE DROP;" statement, where "field name" refers to the name of the field that needs to be deleted from the table.

Mysql delete field

Deleting a field removes a field from the data table in the following syntax format:

ALTER TABLE DROP

Where Field name refers to the name of the field that needs to be deleted from the table.

Example:

Mysql > DESC tb_emp1 +-+-+ | Field | Type | Null | Key | Default | Extra | + -+ | col1 | int (11) | YES | | NULL | id | int (11) | YES | | NULL | | name | varchar (30) | YES | | NULL | | col2 | int (11) | YES | | NULL | deptId | int (11) | YES | NULL | | salary | float | YES | | | NULL | | +-+-+ 6 rows in set (0.00 sec) |

(recommended tutorial: mysql video tutorial)

Use ALTER TABLE to modify the structure of table tb_emp1 and delete the col2 field

Mysql > ALTER TABLE tb_emp1-> DROP col2;Query OK, 0 rows affected (.53 sec) Records: 0 Duplicates: 0 Warnings: 0mysql > DESC tb_emp1 +-+-+ | Field | Type | Null | Key | Default | Extra | + -+ | col1 | int (11) | YES | | NULL | id | int (11) | YES | | NULL | | name | varchar (30) | YES | | NULL | | deptId | int (11) | YES | | NULL | salary | float | YES | | NULL | | +-+-- | -+ 5 rows in set (0.00 sec) this is the end of the article on "how mysql deletes table fields". Hope that the above content can be helpful to you, so that you can learn more knowledge, if you think the article is good, please share it for more people to see.