关键字段
- alter table table_name ******
参数
- 修改某字段
alter table table_name modify field_name field_info
ex:
alter table users modify user_name varchart(255) not null default 'test name'
- 增加一个字段
//加字段
alter table table_name add field_name field_info
ex:
alter table users add user_name varchart(255) not null default 'test name'
- 增加索引
//普通索引
alter table table add index index_name(field1,field2,field3)
ex:
alter table users add index email_name_index(email,user_name)
//主键索引
ALTER TABLE `table_name` ADD PRIMARY KEY ( `column` )
ex:
alter table users id add primary key (id)
//唯一索引
ALTER TABLE `table_name` ADD UNIQUE
ex:
alter table users add unique (email)
//全文索引
ALTER TABLE `table_name` ADD FULLTEXT ( `column`)
ex:
alter table users add fulltext(username)
- 修改字段
alter table tablename change old_field_name new_field_name old_type
ex:
alter table users change name username varchart(255) not null default ''
- 修改表结构支持emoji 表情
alter table TABLE_NAME convert to character set utf8mb4 collate utf8mb4_bin
ex:
alter table users convert to character set utf8mb4 collate utf8mb4_bin
- 修改字段位置
//移到某字段之后
alert TABLE table_name MODIFY column1 field_info AFTER column2
ex:
alter table users modify username varchar(255) after email
//移动到第一个位置
alter TABLE table_name MODIFY column1 field_info FIRST
ex:
alter table users modify email varchar(255) first
- 删除字段
alter TABLE table_name drop column column_name
ex:
alter table users drop column email
- 删除索引
alter table table_name drop index index_name
ex:
alter table users drop index email_name_index