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 database to another database
> 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, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
