MYSQL 删除重复数据并保留ID最小的一条

1,188次阅读
没有评论

[code]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)[/code]

正文完
 
谷川
版权声明:本站原创文章,由 谷川 2018-11-14发表,共计190字。
转载说明:除特殊说明外本站文章皆由CC-4.0协议发布,转载请注明出处。
评论(没有评论)