Myql-重複除外
DELETE FROM `supplier` WHERE id IN (SELECT * FROM (SELECT MAX(id) FROM `supplier` GROUP BY NAME HAVING(COUNT(*)>1)) AS tmp);
仕入先から重複したデータを削除し、IDの小さい
DELETE FROM `supplier` WHERE id IN (SELECT * FROM (SELECT MAX(id) FROM `supplier` GROUP BY NAME HAVING(COUNT(*)>1)) AS tmp);