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);
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);
转载于:https://www.cnblogs.com/dcj890828/articles/5741751.html