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

["Jerry Schwartz" <jschwartz@xxxxxxxxxxxxxxxx>]

Yes

Regards,

Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032

860.674.8796 / FAX: 860.674.8341

www.the-infoshop.com
www.giiexpress.com
www.etudes-marche.com

-----Original Message-----
From: Christoph Boget [mailto:christoph.boget@xxxxxxxxx]
Sent: Thursday, April 10, 2008 1:09 PM
To: Paul DuBois
Cc: Larry Brown; Mysql
Subject: Re: select records to send to another table in another database

> > 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;

And you can do that using the cli mysql app?

thnx,
Chris

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





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