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?
If the tables have the same schema, you should be able to just
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
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?
If the tables have the same schema, you should be able to just
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
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:
At 1:09 PM -0400 4/10/08, Christoph Boget 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
On Thu, 2008-04-10 at 11:43 -0500, Paul DuBois wrote:
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
That is exactly what I was looking for. Thank you all