DELETE FROM `supplier` WHERE id IN (SELECT * FROM (SELECT MAX(id) FROM `supplier` GROUP BY NAME HAVING(COUNT(*)>1)) AS tmp);
去除供应商中重名的数据,保留ID小的
本文出自 “web之路” 博客，请务必保留此出处http://liuzhongcool.blog.51cto.com/10509488/1675626
原文：http://liuzhongcool.blog.51cto.com/10509488/1675626