Re: select records to send to another table in another database

[Paul DuBois <paul@xxxxxxxxx>]

At 12:21 PM -0400 4/10/08, Larry Brown wrote:
> I have a slew of records that went to the wrong database.  The tables
> have the same names and now I want to copy those records over to the
> correct database.  Is there such a mechanism using the cli mysql
> application in Linux?

For each corresponding table:

INSERT INTO db1.mytable SELECT * FROM db2.mytable;

--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=royale@xxxxxxxxxx