通过另一个表中的列更新一个表中的列。

I have 2 tables 'A' and 'B'. Both have a common column 'name' and linked with each other by a column 'id'. The column 'name' in the table A is empty whereas it has data in table B. My task is to fill all the data in that column from table B to table A with corresponding ids.I have 2 tables 'A' and 'B'. Both have a common