读书人

剔除重复记录只保留一条

发布时间: 2012-08-14 10:39:57 作者: rapoo

删除重复记录,只保留一条
delete from `tieba` where id in (select id from (SELECT *,count(`name`) as num FROM `tieba`group by `name`) as b where num>1)

读书人网 >其他数据库

热点推荐