Forget that! I should read the question more acrefully - you want between different databases!! There I can't help you I'm afraid. (doh!) .steve ######################## http://www.cookstour.org ######################## > -----Ursprungligt meddelande----- > Från: Steve Cook > Skickat: den 17 september 2003 10:56 > Till: thelist at lists.evolt.org > Ämne: SV: [thelist] MySql - Copy between databases > > > 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 > > > <SNIP>