mysql批量根据备份表修改原表数据

作者官方网站:http://www.wxl568.cn

update tm_clock_address w inner join tm_clock_address20170824 e on w.id = e.id
set 
w.name = e.name,
w.address = e.address,
w.longitude= e.longitude,
w.latitude = e.latitude;