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
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 e
: 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
> > 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.mytab
> 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 jus
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 jus