delete from test where id not IN
(
SELECT tmp.id FROM (
SELECT id FROM test
GROUP BY NAME
) tmp
)
mysql删除重复数据只保留一条
最新推荐文章于 2019-03-19 14:27:13 发布
delete from test where id not IN
(
SELECT tmp.id FROM (
SELECT id FROM test
GROUP BY NAME
) tmp
)