This is off the top of my head so check the manual on this.
insert into db1.table from db2.table where...
- Original Message -
From: "Dang Nguyen" <[EMAIL PROTECTED]>
To: "'mySQL mailing list'" <[EMAIL PROTECTED]>
Sent: Friday, January 12, 2001 4:27
Subject: copying rows from one databas
I think you need to copy data first then delete the data.
copying data between two databases:
insert into databaseA.table select * from databaseB.table where .
delete data :
delete from databaseB.table where ...
Dang Nguyen wrote:
>
> Hi All,
>
> What is the best way
