Deleting a table field is to remove a field in the data table from the table. You can use the "ALTER TABLE
DROP
;" statement; where, "Field name" refers to the name of the field that needs to be deleted from the table.
The operating environment of this tutorial: windows7 system, Dell G3 computer, mysql8.
mysql delete field
Deleting a field is to remove a field in the data table from the table. The syntax format is as follows:
ALTER TABLE <表名> DROP <字段名>；Copy after loginwhere , "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)Copy after login(Recommended tutorial: mysql video tutorial)
Use ALTER TABLE to modify the structure of table tb_emp1, Delete col2 field
mysql> ALTER TABLE tb_emp1 -> DROP col2; Query OK, 0 rows affected (0.53 sec) Records: 0 Duplicates: 0 Warnings: 0 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 | | | deptId | int(11) | YES | | NULL | | | salary | float | YES | | NULL | | +--------+-------------+------+-----+---------+-------+ 5 rows in set (0.00 sec)Copy after loginFor more programming-related knowledge, please visit:Programming Teaching! !
The above is the detailed content of How to delete table fields in mysql. For more information, please follow other related articles on the PHP Chinese website!
Previous article：Introducing advanced MySQL database SQL statements Next article：How to create a data table in mysql databaseStatement of this WebsiteThe content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cnLatest Articles by Author
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
