Update identical table

From: Date: Sat, 28 Sep 2002 12:28:54 +0000
Subject: Update identical table
Groups: php.general 
Request: Send a blank email to php-general+get-117935@lists.php.net to get a copy of this message
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

« previous php.general (#117935) next »