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

["Christoph Boget" <christoph.boget@xxxxxxxxx>]

> > 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=royale@xxxxxxxxxx