问题:
假设x表中的数据为
![](https://img.haomeiwen.com/i3013797/ea6ab95d1dd0a68d.png)
y表中的数据为
![](https://img.haomeiwen.com/i3013797/d1f9dc3a3bd8c57d.png)
如何把x表里面字段a,b和y表里面a,b相同的删除?
尝试:
DELETE FROM x WHERE a IN (SELECT a FROM y) AND b IN (SELECT b FROM y);
这样做是错误的,把x表中所有数据都删除了
解决办法:
DELETE FROM x WHERE (a,b) IN (SELECT a,b FROM y);
假设x表中的数据为
y表中的数据为
如何把x表里面字段a,b和y表里面a,b相同的删除?
DELETE FROM x WHERE a IN (SELECT a FROM y) AND b IN (SELECT b FROM y);
这样做是错误的,把x表中所有数据都删除了
DELETE FROM x WHERE (a,b) IN (SELECT a,b FROM y);
本文标题:sql语句,把x表里面字段a,b和y表里面a,b相同的删除
本文链接:https://www.haomeiwen.com/subject/omsshctx.html
网友评论