A是需要批量更新的主表,B是查询匹配条件的副表;
批量更新A表的IsNoEnable状态,更新条件为:查询A表的Id值,查询条件为A表与B表相同的Sid
UPDATE A SET IsNoEnable=1 WHERE Id IN(
SELECT
a.id
FROM
A AS a,
B AS b
WHERE
a.SId = b.SId
)
A是需要批量更新的主表,B是查询匹配条件的副表;
批量更新A表的IsNoEnable状态,更新条件为:查询A表的Id值,查询条件为A表与B表相同的Sid
UPDATE A SET IsNoEnable=1 WHERE Id IN(
SELECT
a.id
FROM
A AS a,
B AS b
WHERE
a.SId = b.SId
)