delete evalustion as a from evaluation as a ,
(select * from evaluation group by month having count(1) > 1)
as b where a.month = b.month and a.id <> b.id;
mysql 中删除某个字段重复的SQL语句
最新推荐文章于 2023-11-16 19:21:02 发布
delete evalustion as a from evaluation as a ,
(select * from evaluation group by month having count(1) > 1)
as b where a.month = b.month and a.id <> b.id;