1.增删索引
1.添加索引
// 添加主键索引
alter table table_name add primary key (column_name)
//添加唯一索引
alter table table_name add unique (column_name)
//添加普通索引
alter table table_name add index index_name(column_name)
2.删除索引
//
alter table table_name drop primary key
alter table table_name drop index index_name
drop index index_name on table_name
3.查看索引
show index from table_name
2.增删列
1.增加列
//新增列
alter table table_name add column column_name varchar(20) not null
//指定位置新增列 after
alter table table_name add column column_name varchar(20) not null after COLUMN_NAME
//添加到第一列 first
alter table table_name add column column_name varchar(20) not null first
2.删除列
//
alter table table_name drop column_name
3.修改列信息
//
alter table table_name change column_name new_column_name varchar(20) not null