/ mysql / 【mysql】删除字段重复数据并保留一条

【mysql】删除字段重复数据并保留一条

小涛 7 天前 27

代码

delete lj_copy1 from lj_copy1, ( SELECT min(id) id,lj FROM lj_copy1 GROUP BY lj HAVING count(*) > 1 ) t2 where lj_copy1.lj = t2.lj and lj_copy1.id > t2.id
点赞 0

小涛

最新文章