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)
>
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)
>
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 po