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`
FROM `dbase1`.`table1` ;

That will copy from 1st database to second. If you use phpMyAdmin you can do
it via the "operations" tab.


PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to