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

[Larry Brown <larry.brown@xxxxxxxxxxxxxxxxxxxxx>]

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 very much.  

Larry

-- 
Larry Brown <larry.brown@xxxxxxxxxxxxxxxxxxxxx>


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=royale@xxxxxxxxxx