SELECT * FROM table1 t1, table2 t2
WHERE t1.id=t2.id
update table1 t1, table2 t2
set t1.dist_filepath=t2.dist_filepath,t1.dist_filename=t2.dist_filename
WHERE t1.id=t2.id