RE: [PHP] Update identical table

> 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 ...). Why not have just one table with a flag that says whether it's a temp row or not?? It would make things easier and not replicate data. If you don't want to do that, use the INSERT INTO table2 SELECT ... FROM table1 WHERE ... ---John Holmes...