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 corresponding table:
INSERT INTO db1.mytable SELECT * FROM db2.mytable;
And you can do that using the cli mysql app?
Yes. You can do this in any interface that enables you to
issue SQL statements.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]