delete 进行关联删除,有以下下方法参考:
1、in or exist(量大是不推荐in)
DELETE FROM A
WHERE EXISTS
(SELECT 1 FROM B WHERE A.CID=B.CID and B.cp = 2);
2、join,关联删除
delete A
from A ,B
where A.CID=B.CID and B.cp = 2;
or
delete A
from A
inner join B
on A.CID=B.CID
where B.cp = 2;
推荐使用第二种