一些常用但是易忘的关于alter的sql语句

修改表名：alter table table_old_name rename to table_new_name

修改id为自增并设为主键：alter table table_name modify column_name int auto_increment primary key

修改字段类型：alter table table_name alter column column_name set default 0

修改字段名称:alter table table_name change column_old_name column_new_name varchar(255) default '' 

修改一个字段的类型：alter table table_name modify  column_name varchar(10)

添加主键索引：alter table table_name add primary key('column_name')

添加唯一索引：alter table table_name add unique('column_name')

添加全文索引：alter table table_name add fulltext('column_name')

添加多列索引:alter table table_name add index index_name ('column_name1','column_name2','column_name3')

转载于:https://my.oschina.net/passer007/blog/648363