我想要在多个表中使用相同的条件(where子句)删除数据。
有没有一种方法可以声明一个列表,以存储上述选择语句中的ID?
我尝试过: ```python my_list = [] my_list.append(SELECT id FROM table) ``` 但它不起作用。
delete from tblA where id in (select x.id from tblX x where name like N'%test%')
delete from tblB where id in (select x.id from tblX x where name like N'%test%')
delete from tblC where id in (select x.id from tblX x where name like N'%test%')
delete from tblD where id in (select x.id from tblX x where name like N'%test%')
有没有一种方法可以声明一个列表,以存储上述选择语句中的ID?
我尝试过: ```python my_list = [] my_list.append(SELECT id FROM table) ``` 但它不起作用。
declare @ids int
set @ids = select x.id from tblX x where name like N'%test%'
但它抱怨说
子查询返回的值超过1个。当子查询跟随=,!=,<,<=,>,>=时,或者当子查询用作表达式时,不允许出现这种情况。
请给予建议,谢谢。