Home >Database >Mysql Tutorial >How to delete a column in mysql

How to delete a column in mysql

藏色散人
藏色散人Original
2019-05-10 13:28:3636746browse

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.

How to delete a column in mysql

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!

Statement:
The 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.cn