可以用sql实现同样的功能,就是麻烦了点。
drop table t1; drop table t2;create table t1(id int primary key,nickname varchar(20),playnum varchar(20));create table t2(id int primary key,nickname varchar(20),playnum varchar(20));insert into t1 values(1,1,10);insert into t1 values(2,2,20);insert into t1 values(3,3,30);insert into t2 values(1,1,10);insert into t2 values(2,2,200);insert into t2 values(3,33,300);commit;
mysql实现交集
select id, nickname, playnum, count(*) from (select id, nickname, playnumfrom t1union allselect id, nickname, playnumfrom t2) agroup by id, nickname, playnumhaving count(*) > 1
mysql实现差集
select t1.id, t1.nickname, t1.playnum from t1 left join t2 on t1.id = t2.idwhere t1.nickname != t2.nicknameor t1.playnum != t2.playnum;