anhuihaiwei2005 回复 用户MtzZM5884(提问者)使用for in loop 批量更改
BEGIN
FOR 表1 IN (
SELECT [匹配字段]，[更新字段] FROM A表
) loop
UPDATE B表
SET B表.[需要更新字段]= 表1.[更新字段]；
WHERE
B表.[匹配字段]= 表1.[匹配字段];
END loop ;
END;
用户MtzZM5884(提问者) 回复 anhuihaiwei2005UPDATE tb_busirecord tb SET tb.ts =
(
select a.ts1 from
(
(select concat(billdate,\' 00:00:00\') ts1 from
(select * from tb_busirecord where ts is null))
) a
where substr(a.ts1,1,10) = tb.billdate
)
1min目标场景问卷
立即参与
