This probably does what you want... http://www.mysql.com/doc/en/INSERT_SELECT.html INSERT ... SELECT It's not explained in depth and I haven't used it myself, but I'm sure a little digging will turn up some examples. .steve ######################## http://www.cookstour.org ######################## > -----Ursprungligt meddelande----- > Från: Ken Moore [mailto:cor412 at hotmail.com] > Skickat: den 17 september 2003 10:45 > Till: thelist at lists.evolt.org > Ämne: [thelist] MySql - Copy between databases > > > Hi all, > > Is there any way to copy records between databases without > exporting and then importing? > <SNIP>