mysql批量刷表:
update a
inner join c
on a.id= c.id
and a.grade = c.grade
set a.name = c.name,
a.clazz = c.clazz
where a.name is null and a.clazz is null;
说明:
1、更新a表,b可以是个表也可以是个中间表。
2、set后面是更新的字段,on后面是两者表的关联关系,确定唯一一条数据
postgre批量刷表:
update tmp_gzd
set fzrcode = sys_user.user_id
from sys_user
where tmp_gzd.fzr = sys_user.nick_name;