update table tableA set tableA.a = (select tableB.b from table tableB where tableA.id = tableB.id)
update 表名 set a=b
