mysql 删除重复数据，需要给子查询的表，起一个别名

delete from think_cmport_jpg_copy where id not in (SELECT a FROM (select MAX(id) as a from `think_cmport_jpg_copy` group by `value`) b);