- A+
所属分类：个人原创
DELETE FROM mtk
WHERE
`code` IN (SELECT
*
FROM
(SELECT
`code`
FROM
mtk
GROUP BY `code`
HAVING COUNT(`code`) > 1) t1)
AND id NOT IN (SELECT
*
FROM
(SELECT
MIN(id)
FROM
mtk
GROUP BY `code`
HAVING COUNT(`code`) > 1) t2)
- 版权声明：本站原创文章，于2018 年 11 月 14 日13:59:41，由 谷川 发表，共 190 字。
- 转载请注明：MYSQL 删除重复数据并保留ID最小的一条 | 川视界
