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
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
Hi All,
What is the best way to move an entire row of data from a table in one
database to another table in a different database? The two databases are on
the same system.
Thanks in advance,
Dang H. Nguyen
-
Before posting, pl
