试试这个 Delete A where exists (select 1 from B where A.x=B.x)
DELETE A FROM A INNER JOIN B ON B.x=A.x
Delete A From A inner join B on A.x=B.x
1 . delete from a from a , b where a.x = b. x 2 . delete from a inner join b on a.x = b.x 3 . delete from a where exists(select 1 from b where a.x = b.x)
各位老师 1 . delete from a from a , b where a.x = b. x 2 . delete from a inner join b on a.x = b.x 3 . delete from a where exists(select 1 from b where a.x = b.x)他们的解释,也就是他们的语句意思中每个实际执行过程是啥意思,我 没弄明白,他们到底那个快为什么
Delete A where exists (select 1 from B where A.x=B.x)
on A.x=B.x
2 . delete from a inner join b on a.x = b.x
3 . delete from a where exists(select 1 from b where a.x = b.x)
1 . delete from a from a , b where a.x = b. x
2 . delete from a inner join b on a.x = b.x
3 . delete from a where exists(select 1 from b where a.x = b.x)他们的解释,也就是他们的语句意思中每个实际执行过程是啥意思,我 没弄明白,他们到底那个快为什么