Shulou(Shulou.com)05/31 Report--

This article is about how to modify the table structure of MySQL database. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

MySQL ALTER TABLE statement

ALTER TABLE table_name action1 [, action2, …]

First, specify the name of the table to change after the ALTER TABLE clause.

Second, list a set of actions to apply to the table. The action can be to add a new column, add a primary key, rename the table, and so on. The ALTER TABLE statement allows multiple operations to be applied in a single ALTER TABLE statement, each separated by a comma (,).

First, create a new database:

CREATE TABLE tasks (id INT NOT NULL, subject VARCHAR (45) NULL, start_date DATE NULL, end_date DATE NULL,) charset utf8

1) modify the table name

Alter table tasks rename student

2) modify the storage engine of the table

Alter table student ENGINE=MyISAM

3) remove columns from the table

Alter table student drop column end_date

4) add a new column to the table (use after,before for specific location)

Alter table studentadd column complete DECIMAL (2Jing 1) NULLAFTER subject

5) modify field name and field definition

Alter table student change subject math varchar (20)

6) modify field definition

Alter table student modify math varchar (10); Thank you for reading! On "how to modify the table structure of the MySQL database" this article is shared here, I hope the above content can be of some help to you, so that you can learn more knowledge, if you think the article is good, you can share it out for more people to see it!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.