MySQL 唯一索引

创建表时

create table user(id int not null auto_increment, name varchar(20) not null, primary key(id),UNIQUE(name));

添加

alter table user add unique index(name);

删除

alter table user drop index name;