mysql让一列赋值给另一列 赋值t2表的col2列值给t1表的col1列 UPDATE table1 t1 INNER JOIN table2 t2 ON t1.id=t2.t1_id SET t1.col1=t2.col2;