IN中的数据量不能大于2K条,否则会报错
先使用SELECT语句将数据查询到一张临时表
然后使用INNER JOIN进行内联删除
delete from A where a_id in (select id from B where b_id in
1个回答
相关问题
-
select * from table_a a where a.id not in (id1,id2,id3.) 中的i
-
select top 10 * from (select top 40 * from a order by id asc
-
_____in your handbag ,Madam Some money and ID card A Where i
-
sql如何写四张表结构如下：A[id, 字段1], B[id,A_id, C_id], C[id], D[id, C_i
-
SQL语句理解 select * from B where (select count(1) as num from A
-
ms sql :select * from (select *from b) as xxx where 和 select
-
i don't know ----my id card is.a,which b.where c.whose d.whe
-
select * from table_a a,table_b b where a.col1 = b.col1(+) ;
-
select * from v$locked_object a,user_objects b where a.OBJEC
-
—where is my id card? i don’t know.please a ___jim.