mysql查询消除重复 mySQL删除相同数据的SQL语句怎么写 – 数据库 – 前端 mysql建立存储过程

如果所有重复的内容都删掉可以试试 delete from t where id not in ( select id from t group by c1, c2, c3, c4 having count (*) < 2)