a表中的name字段有值,b表name字段为空,现要把a表name字段的值赋值到b表相应id的name中去!~ update a set a.name = (select name from b where a.id = b.id);