本文提供了一个SQL脚本，用于从数据库表machine_score中删除重复记录，仅保留每种model的最小id值。
- 修改自己表里面重复的数据，只保留一条
create table temp as select id as c
from machine_score where model in ( select model
from machine_score GROUP BY model HAVING count(*) > 1 )
and id not in (select min(id) from machine_score GROUP BY model)
扫一扫
评论
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
查看更多评论
添加红包
