update t_e_cj_stu_subject_score
set stuid = t2.userid
from public.tmp_student t2
where stuname = t2.name and examid = 'EX0000000116' ;
pgsql update left join
编程PDF电子书免费下载： http://www.shitanlife.com/code 每天学习一点点
update t_e_cj_stu_subject_score
set stuid = t2.userid
from public.tmp_student t2
where stuname = t2.name and examid = 'EX0000000116' ;