SV: [thelist] MySql - Copy between databases

Ken Moore cor412 at hotmail.com
Wed Sep 17 04:04:58 CDT 2003


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



More information about the thelist mailing list