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
