SQL update select结合语句详解及应用

update table_name
set column_name1 = value whrer column_name2 = value

insert into table1
(c1, c2, c3)
(select v1, v2, v3 from table2)

update table1 alias
set (column_name,column_name ) = (
select (column_name, column_name)
from table2
where column_name = alias.column_name)
where column_name = value

id  name 
1   王 
2   李 
3   张

id clientname 
1 
2 
3

update b  set  clientname  = a.name  from a,b  where a.id = b.id

update b  set  (clientname)  =  (select name from a where b.id = a.id)

update t_orderform set t_orderform.sellerid =b.l_tuserid
from t_orderform a left join t_productinfo  b on b.l_id=a.productid

update a set (a1, a2, a3) = (select b1, b2, b3 from b where a.id = b.id)

update a set a1 = b1, a2 = b2, a3 = b3 from a left join b on a.id = b.id

update a set a1 = b1, a2 = b2, a3 = b3 from a, b where a.id = b.id

update a set (a1, a2, a3) = (select b1, b2, b3 from b where a.id = b.id)
where id in (select b.id from b where a.id = b.id)