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