Transfer data between tables in MySQL
| From: | Rosen | Date: | Wed, 29 Nov 2006 11:44:24 +0000 |
| Subject: | Transfer data between tables in MySQL | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-42763@lists.php.net to get a copy of this message | ||
Hi,
I have to transfer all data between two tables ( with identical structure )
Is this possible with one query, or I must read from table1 and manually
insert into table2?
Thanks in advance,
Rosen