mysql更改表结构

原网址： https://www.cnblogs.com/Anidot/articles/7666909.html

删除列:

ALTER TABLE person DROP COLUMN birthday; 

添加列: 
ALTER TABLE person ADD COLUMN birthday datetime;
 
修改列,把number修改为bigint:
ALTER TABLE person MODIFY number BIGINT NOT NULL;
ALTER TABLE person CHANGE number id BIGINT;
 
添加主键:

ALTER TABLE person ADD PRIMARY KEY (id);

删除主键:
ALTER TABLE person DROP PRIMARY KEY;
 
添加唯一索引:

ALTER TABLE person ADD UNIQUE name_unique_index (`name`);

添加普通索引:
ALTER TABLE person ADD INDEX birthday_index (`birthday`);
 
删除索引:
ALTER TABLE person DROP INDEX birthday_index;

ALTER TABLE person DROP INDEX name_unique_index;

更改表名:

ALTER  TABLE admin_user RENAME TO a_user

修改表列名

alter table testtable change  column address address1 varchar(30)