clwn.net
当前位置:首页 >> mysql 差集 >>

mysql 差集

select URL from TABLEA where url not in (select URL from TABLEB where APP_NAME=TABLEA.APP_NAME)

只是查询,不做删除吧: SELECT * FROM 表1 WHERE name NOT IN ( SELECT name FROM 表2 )

只是查询,不做删除吧: SELECT * FROM 表1 WHERE name NOT IN ( SELECT name FROM 表2 )

CREATE TABLE A ( `C1` VARCHAR(10), `C2` VARCHAR(10), `C3` VARCHAR(10), `C4` VARCHAR(10), `C5` INT ); INSERT INTO A SELECT '华北', '辽宁', '沈阳', '20020202', 2 UNION ALL SELECT '华东', '山东', '青岛', '18020133', 3 UNION ALL SE...

网站首页 | 网站地图
All rights reserved Powered by www.clwn.net
copyright ©right 2010-2021。
内容来自网络,如有侵犯请联系客服。zhit325@qq.com