MySQL实现差集(Minus)和交集(Intersect)测试报告
MySQL实现差集(Minus)和交集(Intersect)测试报告
发布时间:2016-12-29 来源:查字典编辑
摘要:可以用SQL实现同样的功能,就是麻烦了点。droptablet1;droptablet2;createtablet1(idintprimar...

可以用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实现差集(Minus)和交集(Intersect)测试报告1

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实现差集(Minus)和交集(Intersect)测试报告2

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;

MySQL实现差集(Minus)和交集(Intersect)测试报告3

推荐文章
猜你喜欢
附近的人在看
推荐阅读
拓展阅读
相关阅读
网友关注
最新mysql数据库学习
热门mysql数据库学习
编程开发子分类