LNMP集成环境

Publish: February 8, 2012 Category: PHP,MYSQL,Centos,Nginx 367 Comments

http://lnmp.org/

联合索引及数据排重

Publish: February 2, 2012 Category: MYSQL 811 Comments 

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)

# 数据排重
ALTER IGNORE TABLE dict ADD UNIQUE INDEX(content);
  1. 1