Question

sql怎样将a 表中的值赋予到b表中不同字段的值

Answer 1

update B set extra = A.extra from A join B on (A.id = B.id);