Delete from join 用法

delete from tblA left join tblb on。。。用法


1、delete from left join

delete from用法

DELETE A FROM YSHA A LEFT JOIN YSHB B ON A.code=b.code WHERE b.code is NULL
SELECT * FROM YSHA
SELECT * FROM YSHB


等同于

DELETE FROM YSHA WHERE NOT EXISTS(SELECT 1 FROM YSHB B WHERE YSHA.code=b.code )
SELECT * FROM YSHA
SELECT * FROM YSHB

以上操作是将B表中未使用的A表编号删除


3、delete from A，B

delete from 用法

DELETE A FROM YSHA A , YSHB B WHERE A.code=b.code
SELECT * FROM YSHA
SELECT * FROM YSHB

等同于

DELETE FROM YSHA WHERE EXISTS(SELECT 1 FROM YSHB B WHERE YSHA.code=b.code )
SELECT * FROM YSHA

SELECT * FROM YSHB