删除重复数据mysql

DELETE FROM draw_img WHERE id NOT IN (SELECT *                     FROM (SELECT MAX(n.id)                            FROM draw_img n                        GROUP BY n.content) x)

其中group by的字段需要加索引

一万条数据需要6s