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"" <bastien_k@xxxxxxxxxxx> wrote in message news:BAY135-F36BD21AC8FB8CE754E17AF9DE40@xxxxxxxxxx > 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
