Rosen wrote: > 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 INSERT INTO `dbase2`.`table1` SELECT * FROM `dbase1`.`table1` ; That will copy from 1st database to second. If you use phpMyAdmin you can do it via the "operations" tab. BMA -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
