mysql 根据多字段去重

原文链接：https://blog.csdn.net/wang1qqqq/article/details/115241993

delete from tableA
where c_id in (
select * from
(select c_id from tableA
where c_id not in
(select min(c_id) from tableA
group by c_name,c_year,c_month
)) a
)
————————————————