mysql把A表查询结果塞到B表

UPDATE table_a  
JOIN table_b ON table_a.data_id = table_b.data_id  
SET table_a.name = table_b.name;