[thelist] RE: Copy between databases, Thank you

Ken Moore cor412 at hotmail.com
Wed Sep 17 07:30:54 CDT 2003


Jason,

Thanks. It does work.

Ken

>From: "Jason Handby" <jasonh at corestar.co.uk>
>Reply-To: "thelist at lists.evolt.org" <thelist at lists.evolt.org>
>To: <thelist at lists.evolt.org>
>Subject: RE: SV: [thelist] MySql - Copy between databases
>Date: Wed, 17 Sep 2003 10:16:50 +0100
>MIME-Version: 1.0
>Received: from acornparenting.org ([216.40.227.23]) by mc12-f9.hotmail.com 
>with Microsoft SMTPSVC(5.0.2195.5600); Wed, 17 Sep 2003 02:18:40 -0700
>Received: (qmail 15366 invoked from network); 17 Sep 2003 09:17:00 -0000
>Received: from localhost (HELO www.acornparenting.org) (127.0.0.1)  by 0 
>with SMTP; 17 Sep 2003 09:17:00 -0000
>Received: (qmail 15335 invoked from network); 17 Sep 2003 09:16:45 -0000
>Received: from shockwave.systems.pipex.net (62.241.160.9)  by 0 with SMTP; 
>17 Sep 2003 09:16:45 -0000
>Received: from shine (userbe138.dsl.pipex.com [62.190.244.138])by 
>shockwave.systems.pipex.net (Postfix) with SMTP id 021251C00668for 
><thelist at lists.evolt.org>; Wed, 17 Sep 2003 10:16:44 +0100 (BST)
>X-Message-Info: JGTYoYF78jGPbwlIZNZWQbbQ2X48Bly3
>Return-Path: <jasonh at corestar.co.uk>
>Delivered-To: thelist at lists.evolt.org
>Message-ID: <DIEPJJHJLEDGNOPBGMCAEENDCJAA.jasonh at corestar.co.uk>
>X-Priority: 3 (Normal)
>X-MSMail-Priority: Normal
>X-Mailer: Microsoft Outlook IMO, Build 9.0.6604 (9.0.2911.0)
>In-Reply-To: <Sea1-F850RnLJm2ZBNC0000727a at hotmail.com>
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
>Importance: Normal
>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 09:18:40.0803 (UTC) 
>FILETIME=[AF1D1F30:01C37CFC]
>
>Hi Ken,
>
> > insert ... select works between tables in a single database. It does not
> > seem to work between databases.
>
>You *should* be able to refer to tables in different databases using the 
>dot
>notation, e.g.
>
>	INSERT INTO db2.mytable SELECT * FROM db1.mytable
>
>I haven't tried this, but it ought to work.
>
>
>J
>
>--
>* * 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 !

_________________________________________________________________
Send and receive larger attachments with Hotmail Extra Storage.   
http://join.msn.com/?PAGE=features/es



More information about the thelist mailing list