mysql 更新两表

update table c1,table c2 set c1.field1 = c2.field1,c1.field1_tree_id = c2.field1_tree_id where c1.name=c2.name and c1.province_id =c2.province_id