您的位置首页快问快答

delete from语句

delete from语句

的有关信息介绍如下:

delete from语句

delete from A left join B on A.GUID=B.GUID where B.GUID is null

不考虑性能就用IN咯,比上一条要短一点

delete from A where GUID not in (select GUID from B)