这个有个值得注意的地方就是,不要直接更新区域,否则会造成下单大面积失败的!!!!!!!
SELECT * FROM `xcxmall_district_0407` GROUP BY adcode HAVING //3271-3237=34
select id,adcode,name,lng,lat,level,count(adcode) from xcxmall_district_0407 group by adcode having count(adcode)>1 //重复
select count(DISTINCT(adcode)) from xcxmall_district_0407 //3237