所在位置:主页 > 编程技术 >

编程技术
联系方式
MySQL实现差集(Minus)和交集(Intersect)测试报告
发布时间:2018-12-13 编辑:918Õ

 可以用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;

http://www.bkjia.com/Mysql/824029.htmlwww.bkjia.comtruehttp://www.bkjia.com/Mysql/824029.htmlTechArticle可以用SQL实现同样的功能,就是麻烦了点。 drop table t1; drop table t2;create table t1(id int primary key,nickname varchar(20),playNum varchar(20));create table t2(id...

本文源自: AG环亚娱乐

Copyright © 2005-2016 http://www.ichimail.com AG环亚娱乐_AG环亚官网_AG环亚集团_搜狐娱乐版权所有 AG环亚娱乐_AG环亚官网_AG环亚集团_搜狐娱乐