How to delete a column in mysql

Mysql method to delete a column: [alter table table name drop column column name]. MySQL is a relational database management system. A relational database stores data in different tables instead of placing all data in one large warehouse. This approach improves flexibility.

MySQL is a relational database management system developed by the Swedish MySQL AB company and is currently a product of Oracle. MySQL is one of the most popular relational database management systems. In terms of WEB applications, MySQL is the best RDBMS (Relational Database Management System) application software.

(Recommended tutorial: mysql video tutorial)

MySQL is a relational database management system. A relational database saves data in different tables instead of all The data is housed in a large warehouse, which increases speed and flexibility.

The SQL language used by MySQL is the most commonly used standardized language for accessing databases. MySQL software adopts a dual licensing policy and is divided into community version and commercial version. Due to its small size, fast speed, low total cost of ownership, and especially the characteristics of open source, MySQL is generally chosen as the website database for the development of small and medium-sized websites.

So how to delete a column in mysql?

Mysql statement method to delete a column is:

alter table 表名 drop column 列名;

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