Hi guys, I have 2 identical tables called "tmp_data" and "data". (on the same mysql database). What would be the simple and more convenient way to update table "data" with a row from table "tmp_data". (something like select * from tmp_data and than update data ...).
Thanks a lot, Radu