SqlServer 關聯更新語句:
update a set a.pname = b.name from 表a a inner join 表b b on a.pid = b.id
MySQL 關聯更新語句
UPDATE 表s s LEFT JOIN 表j j ON s.uid = j.id set s.v_name = j.s_name;