-
后期发现sql效率不好,在建立复合主键
但因为测试库里很多垃圾数据,so需要处理到重复数据才能创立主键,
1 查询双主键的sql:
select concat(relation_guid,'|',relation_labelid),count(*) from customerlabel_e00002
group by concat(relation_guid,relation_labelid)
order by 2 desc
2 建立复合主键:
alter table customerlabel_e00002 ADD PRIMARY KEY ( relation_guid,relation_labelid );