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:[EMAIL PROTECTED] 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/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]