2013年8月9日
删除重复记录（Mysql,SqlServer,Sqlite）
摘要： Mysql中有重复的数据：select resource_id,count(1) from t_resource_apptype_releation GROUP BY resource_id having count(1)>1 order by count(1) desc删除一下吧：delete a from t_resource_apptype_releation as a,(select *,min(id) from t_resource_apptype_releation group by resource_id having count(1) > 1) as b where 阅读全文
posted @ 2013-08-09 08:03 糖豆爸爸 阅读(2755) 评论(0) 推荐(0)
Live2D