如何两表关联来删除其中一个表的记录?
delete a
inner join b on b.id=a.id and b.xx=1
DELETE FROM a where exists (select 1 from b where b.id=a.id and b.xx=1 )
如何两表关联来删除其中一个表的记录?
delete a
inner join b on b.id=a.id and b.xx=1
DELETE FROM a where exists (select 1 from b where b.id=a.id and b.xx=1 )