Shulou(Shulou.com)06/01 Report--

Modify the table name:

1. Alter table table name rename to new name

2. Rename table table name to new name

Change the table name, and you can also cross databases.

Example: alter table aa rename to foo.xx

Move the aa table in test to foo and rename it to xx

It is better to move the table in the database than to rename it!

Add columns to the table.

Alter table table name add column name type

Delete the column:

Alter table table name drop column name

Note that you cannot delete all columns of a table, leaving at least one column.

Modify the column definition (you can only change the type of the column, not the name of the column)

Alter table table name

Modify old column name new type

Modify column name and type at the same time

Alter table table name change old column name new column name new type

Modify the character set of the table:

Alter table table name the name of the character set character set

Chuangyue (Shenzhen) Investment Management Co., Ltd.

Cheer for growth

Wechat: CreajoyYOJOY

Weibo: http://weibo.com/CreajoyYOJOY

Official website: http://www.creajoyvc.com/

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.