mysql 修复表中数据重复两次的sql

来源:互联网 发布:软件销售网站 编辑:程序博客网 时间:2024/06/05 04:55
DELETE FROM tableName WHERE id IN (SELECT id FROM (SELECT id ,count(*) AS count FROM tabelName  WHERE HAVING count>1) AS a)
阅读全文
0 0
原创粉丝点击