可以用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, playnum from t1 union all select id, nickname, playnum from t2 ) a group by id, nickname, playnum having count(*) > 1
mysql实现差集
select t1.id, t1.nickname, t1.playnum from t1 left join t2 on t1.id = t2.id where t1.nickname != t2.nickname or t1.playnum != t2.playnum;
如对本文有疑问, 点击进行留言回复!!
linux 安装 MySql 5.7.20 一主多从配置【亲测】 - 之三
Linux: ------ MySQL 基于MyCat的主从复制 读写分离
lower_case_table_names=1 启动报错 mysql8.0
全网最全经典卷积神经网络架构汇总——深度学习之ILSVRC竞赛(ImageNet竞赛)优胜网络结构
网友评论