insert into tableb (select * from tablea)
bastien
From: "Rosen" <rosen@xxxxxxxxxxxxxx>
To: php-db@xxxxxxxxxxxxx
Subject: Transfer data between tables in MySQL
Date: Wed, 29 Nov 2006 13:44:24 +0200
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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
_________________________________________________________________
Find a local pizza place, music store, museum and more?then map the best
route! Check out Live Local today! http://local.live.com/?mkt=en-ca/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
