mysql select in 筛选出不存在的数据

最新推荐文章于 2025-01-04 16:52:04 发布

原创最新推荐文章于 2025-01-04 16:52:04 发布 · 1.2w 阅读

3 ·

CC 4.0 BY-SA版权

Mysql 专栏收录该内容

51 篇文章

订阅专栏

本文介绍了一种使用MySQL从大量指定字符串中筛选出不在特定表中存在的数据的方法。通过创建临时表并利用RIGHT JOIN结合WHERE子句来实现这一目标。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

mysql select in 筛选出不存在的数据：

我想在

'z91w_-j','iok_gg','panjianwei2124','zxm99','opening','donglinchao','panjianwei','zhuenke','whzhaojing','dcba','ytwyh0535','sd-test1','wang123','fuwuzhan111','baizhou','yiyang2124','s706334910','manle','chenchuanping','cgz-janny1314','hk939494615','ludengdeyouhuo','mywmjmzy','chenchengyu','drh123','dyasutoko198412','iok_liaolr','textshangdai','8888888','wewewewewwweee','13601197167','dufengxian520','xdexpohe','iok_jisg','xingshujun','13015377537','demo101','ceshi001','testswfwz1234','demo100','testswfwz123','testswfwz12','testswfwz','testswdb','woxing-test03','tianyi666999','canyousbmore','swdb123','huangyuhe','solafuck','iok_liuy','iok_libm','test_baobao','meizi','iok_sunmeng','zhenxinlai88','azhandj08','hanqun','tangang11122','jacky4470','swfwz','wxswdb4','wxswdb3','wxswdb2','sssxxx','woxingceshi','ceshi009','ceshishangwu','iok_rep_test','astp2012','yxd-joyce','dunweilishangwu','represent123','zhanghongju','zhaojing','yq_represent_test','last_time_represent','majingrui','xing904','iok_zxj','afage','iok_zsh','yuna','bjlinpinyiqi','ioktest','dunxiaowei','shuimojiu','dunhaha','xyl568','azaz','jianghua','plm123','yqdk12345678','yqdk1234567','dhdhdh','qaz123','gdc321','xiaodundun','yutian','xiaomi10','xiaogong','xiaoxiao','marong1','iok_dqz','fangzi','tiangong','bdae1108','liuyihi','iok_zx','222youth','houyuzhao','iok_pjq','iok_yjy','iok_ykm','zhaofeiyan','liyuhu','qitianlei','wangtianming','a291588320','iokokokok','sunchengyanguo','ajh166288','liangrongxing521','guxingyingzimi','liwei99088','vookoo','bessie','zhangfeng001','cd_2012li','zhoujie','pxev','wdp1042559949','deeeee','dededede','gongsong','fengyu','ureture','qitianyu','dengjun','bbbb','gao52085','zhangzunqun','woxingxing','shop','liufeiyan','quruyan','yannanfei','yanruyu','linanxing','qiyufei','guanyuyan','wuqiyuan','bigfit','chengyu','gongfei','wangtian','wangyu','xieziyang','zhaoyumin','liuquan','songyu','qianyu','feiqi','ouyangfei','wuqu','liuyuling','liyuling','qiao','wangbadan','represent3','represent2','viper','aaaaaa','shangwudaibiao2','represent1','shangwudaibiao1','ningyangqqq','123456a'

之中筛选出不存在于member表中的数据怎么操作？

我用的是临时表，如果哪位有更好的方法请通知我一下。

DROP TABLE t1;
CREATE TEMPORARY TABLE t1(NAME VARCHAR(255) NOT NULL);
INSERT INTO t1 VALUES('z91w_-j');
INSERT INTO t1 VALUES('iok_gg');
INSERT INTO t1 VALUES('panjianwei2124');
INSERT INTO t1 VALUES('zxm99');
INSERT INTO t1 VALUES('opening');
INSERT INTO t1 VALUES('donglinchao');
INSERT INTO t1 VALUES('panjianwei');
INSERT INTO t1 VALUES('zhuenke');
INSERT INTO t1 VALUES('whzhaojing');
INSERT INTO t1 VALUES('dcba');
INSERT INTO t1 VALUES('ytwyh0535');
INSERT INTO t1 VALUES('sd-test1');
INSERT INTO t1 VALUES('wang123');
INSERT INTO t1 VALUES('fuwuzhan111');
INSERT INTO t1 VALUES('baizhou');
INSERT INTO t1 VALUES('yiyang2124');
INSERT INTO t1 VALUES('s706334910');
INSERT INTO t1 VALUES('manle');
INSERT INTO t1 VALUES('chenchuanping');
INSERT INTO t1 VALUES('cgz-janny1314');
INSERT INTO t1 VALUES('hk939494615');
INSERT INTO t1 VALUES('ludengdeyouhuo');
INSERT INTO t1 VALUES('mywmjmzy');
INSERT INTO t1 VALUES('chenchengyu');
INSERT INTO t1 VALUES('drh123');
INSERT INTO t1 VALUES('dyasutoko198412');
INSERT INTO t1 VALUES('iok_liaolr');
INSERT INTO t1 VALUES('textshangdai');
INSERT INTO t1 VALUES('8888888');
INSERT INTO t1 VALUES('wewewewewwweee');
INSERT INTO t1 VALUES('13601197167');
INSERT INTO t1 VALUES('dufengxian520');
INSERT INTO t1 VALUES('xdexpohe');
INSERT INTO t1 VALUES('iok_jisg');
INSERT INTO t1 VALUES('xingshujun');
INSERT INTO t1 VALUES('13015377537');
INSERT INTO t1 VALUES('demo101');
INSERT INTO t1 VALUES('ceshi001');
INSERT INTO t1 VALUES('testswfwz1234');
INSERT INTO t1 VALUES('demo100');
INSERT INTO t1 VALUES('testswfwz123');
INSERT INTO t1 VALUES('testswfwz12');
INSERT INTO t1 VALUES('testswfwz');
INSERT INTO t1 VALUES('testswdb');
INSERT INTO t1 VALUES('woxing-test03');
INSERT INTO t1 VALUES('tianyi666999');
INSERT INTO t1 VALUES('canyousbmore');
INSERT INTO t1 VALUES('swdb123');
INSERT INTO t1 VALUES('huangyuhe');
INSERT INTO t1 VALUES('solafuck');
INSERT INTO t1 VALUES('iok_liuy');
INSERT INTO t1 VALUES('iok_libm');
INSERT INTO t1 VALUES('test_baobao');
INSERT INTO t1 VALUES('meizi');
INSERT INTO t1 VALUES('iok_sunmeng');
INSERT INTO t1 VALUES('zhenxinlai88');
INSERT INTO t1 VALUES('azhandj08');
INSERT INTO t1 VALUES('hanqun');
INSERT INTO t1 VALUES('tangang11122');
INSERT INTO t1 VALUES('jacky4470');
INSERT INTO t1 VALUES('swfwz');
INSERT INTO t1 VALUES('wxswdb4');
INSERT INTO t1 VALUES('wxswdb3');
INSERT INTO t1 VALUES('wxswdb2');
INSERT INTO t1 VALUES('sssxxx');
INSERT INTO t1 VALUES('woxingceshi');
INSERT INTO t1 VALUES('ceshi009');
INSERT INTO t1 VALUES('ceshishangwu');
INSERT INTO t1 VALUES('iok_rep_test');
INSERT INTO t1 VALUES('astp2012');
INSERT INTO t1 VALUES('yxd-joyce');
INSERT INTO t1 VALUES('dunweilishangwu');

SELECT t1.name,destoon_member.username FROM destoon_member RIGHT JOIN t1 ON t1.name=destoon_member.username WHERE destoon_member.username IS NULL ;