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

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

小涛 1 年前 1243

代码

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

mysql

手机扫码阅读

微信或手机浏览器扫一扫，随时随地随心阅读与分享

小涛