INSERT INTO data SELECT * FROM tmp_data WHERE condition_definition

Radu Manole wrote:

>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
>
>  
>


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

Reply via email to