MYSQL 删除重复项

delete from g_user_pay_info  where id in 
(
  select id from (select  max(id) as id,
  count(role_id) as count from g_user_pay_info group by role_id 
  having count >1order by count desc) as tab 
)


阅读更多
个人分类: mysql
想对作者说点什么? 我来说一句

没有更多推荐了,返回首页

加入CSDN,享受更精准的内容推荐,与500万程序员共同成长!
关闭
关闭