update 数据。表之间关联 赋值

update A a INNER JOIN B b ON a.a_id=b.b_id set a.new_name = b.old_name
where a.a_id='123456'