首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 数据库 > Mysql >

mysql剔除多字段重复的数据

2012-07-18 
mysql删除多字段重复的数据create table tmp as select min(id) as col1 from blur_article group by titl

mysql删除多字段重复的数据
create table tmp as select min(id) as col1 from blur_article group by title;
delete from blur_article where id not in (select col1 from tmp);
drop table tmp;


create table tmp as select min(id) as col1 from followers group by user_id,follower_id;

delete from followers where id not in (select col1 from tmp);

热点排行