MySQL 大批量插入，过滤掉重复数据

DELETE 
FROM
 table_name
WHERE
 id NOT IN (
 SELECT
  t.id 
 FROM
 ( SELECT MIN( id ) AS id FROM table_name GROUP BY name ) t 
 )

版权声明：本文为yhj198927原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接和本声明。