连表updade和连表delete

DELETE tmp FROM tmp  LEFT JOIN final_tbl  ON tmp.id =final_tbl.id WHERE tmp.id = final_tbl.id

　　

update final_tbl, tmp set final_tbl.last_open_date=tmp.date where final_tbl.id=tmp.id;