create table user(id bigint(10), name varchar(20), qq varchar(10));
alter table user add constraint u_idname unique(id,name);
insert ignore into user values(1, "gcf","345346");
创建联合索引:
alter table user add index idx_union(id, name)
create table user(id bigint(10), name varchar(20), qq varchar(10));
alter table user add constraint u_idname unique(id,name);
insert ignore into user values(1, "gcf","345346");
创建联合索引:
alter table user add index idx_union(id, name)