> I have 2 identical tables called "tmp_data" and "data". (on the same
> database).
> What would be the simple and more convenient way to update table
> 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...

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to