一个SQL删除语句的写法

11 |

可以先找到你要删除记录的主键，然后按条件删除：delete from tawhereta.主键 in(select a.主键 from ta a, tb bwhere a.A = b.A and a.B = b.B)

千问 | 2010-2-2 12:12:50 | 显示全部楼层

delete Tawhere exists(select 1 from TB where A=Ta.A and B=Ta.B)

千问 | 2010-2-2 12:12:50 | 显示全部楼层

delete Tafrom Ta, Tbwhere Ta.A = Tb.A
and Ta.B = Tb.B如果不太灵的话，采用别名，如下书写delete Tafrom Ta x, Tb ywhere x.A = y.A
and x.B = y.B

千问 | 2010-2-2 12:12:50 | 显示全部楼层

delete from Ta where exists(select A,B from Ta left join Tb on Ta.A=Tb.A and Ta.B=Tb.B)

千问 | 2010-2-2 12:12:50 | 显示全部楼层

delete from ta where a in (select a from tb ) andb in (select b from tb)都不知你用的是什么数据库

主题	0 回帖	4882万积分

Rank: 8 Rank: 8

热门排行