RE: [PHP-DB] Transfer data between tables in MySQL
insert into tableb (select * from tablea) bastien From: Rosen [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] 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
Re: [PHP-DB] Transfer data between tables in MySQL
Thanks very much! Before I try something like insert into tableb values (select * from tablea) and it didn't work, but now I see the word values is no needed. Thank you Bastien Koert [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] insert into tableb (select * from tablea) bastien From: Rosen [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] 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
Re: [PHP-DB] Transfer data between tables in MySQL
Thanks very much! Before I try something like insert into tableb values (select * from tablea) and it didn't work, but now I see the word values is no needed. Thank you Bastien Koert [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] insert into tableb (select * from tablea) bastien From: Rosen [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] 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