Re: Update identical table
| From: | Marek Kilimajer | Date: | Sat, 28 Sep 2002 13:43:01 +0000 |
| Subject: | Re: Update identical table | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-117944@lists.php.net to get a copy of this message | ||
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