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

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

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