删除重复数据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