insert ... select works between tables in a single database. It does not seem to work between databases. Ken >From: "Steve Cook" <steve.cook at evitbe.com> >Reply-To: "thelist at lists.evolt.org" <thelist at lists.evolt.org> >To: <thelist at lists.evolt.org> >Subject: SV: [thelist] MySql - Copy between databases >Date: Wed, 17 Sep 2003 10:55:35 +0200 >MIME-Version: 1.0 >Received: from acornparenting.org ([216.40.227.23]) by mc8-f5.hotmail.com >with Microsoft SMTPSVC(5.0.2195.5600); Wed, 17 Sep 2003 01:59:02 -0700 >Received: (qmail 9784 invoked from network); 17 Sep 2003 08:57:06 -0000 >Received: from localhost (HELO www.acornparenting.org) (127.0.0.1) by 0 >with SMTP; 17 Sep 2003 08:57:06 -0000 >Received: (qmail 9730 invoked from network); 17 Sep 2003 08:56:40 -0000 >Received: from nexus.tripnet.se (HELO SBS.ad.evitbe.com) (195.100.170.2) >by 0 with SMTP; 17 Sep 2003 08:56:40 -0000 >X-Message-Info: JGTYoYF78jFd9q3ShzhqQibTinil45uy >Return-Path: <steve.cook at evitbe.com> >Delivered-To: thelist at lists.evolt.org >content-class: urn:content-classes:message >X-MimeOLE: Produced By Microsoft Exchange V6.0.6249.0 >Message-ID: <94B41EC212818F49B4F78F193DEF92D03994D3 at sbs.ad.evitbe.com> >X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [thelist] MySql - Copy >between databases >Thread-Index: AcN8+K3hBrpTM8ZvRvu9F2B6d0W0sQAAJJsA >X-BeenThere: thelist at lists.evolt.org >X-Mailman-Version: 2.1b5 >Precedence: list >List-Id: thelist at lists.evolt.org <thelist.lists.evolt.org> >List-Help: <mailto:thelist-request at lists.evolt.org?subject=help> >List-Post: <mailto:thelist at lists.evolt.org> >List-Subscribe: ><http://lists.evolt.org/mailman/listinfo/thelist>,<mailto:thelist-request at lists.evolt.org?subject=subscribe> >List-Archive: <http://lists.evolt.org/pipermail/thelist> >List-Unsubscribe: ><http://lists.evolt.org/mailman/listinfo/thelist>,<mailto:thelist-request at lists.evolt.org?subject=unsubscribe> >Sender: thelist-bounces at lists.evolt.org >Errors-To: thelist-bounces at lists.evolt.org >X-OriginalArrivalTime: 17 Sep 2003 08:59:02.0795 (UTC) >FILETIME=[F0F75DB0:01C37CF9] > >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> >-- >* * Please support the community that supports you. * * >http://evolt.org/help_support_evolt/ > >For unsubscribe and other options, including the Tip Harvester >and archives of thelist go to: http://lists.evolt.org >Workers of the Web, evolt ! _________________________________________________________________ Get 10MB of e-mail storage! Sign up for Hotmail Extra Storage. http://join.msn.com/?PAGE=features/es