表:T1 id int ,name text
T2 id int,name text,subject text;
通过表T1的name修改T2的name
update T2 set name=(select name from T1 where id=T2.id );
表:T1 id int ,name text
T2 id int,name text,subject text;
通过表T1的name修改T2的name
update T2 set name=(select name from T1 where id=T2.id );