MySQL 常用操作语句

1. 数据去重
   多字段判定唯一去重
   delete from buildings where (query,name) in
   (select query,name from
   (select query,name from buildings group by query,name having count(*)>1 ) as tmp1)

and id not in
(select id from
(select min(id) id from buildings group by query,name having count(*)>1) as tmp2);