At 12:20 PM -0400 1/8/01, Nick Tentomas wrote:
>I believe that one exception to this rule will be if you refer to your
>localhost in your SQL statement. In this case you can combine in
>the same sql statement two different servers.
There are no exceptions to this for MySQL. A statement is sent over
a connection to a single server, and the server won't contact other
servers for you.
>
>Date sent: Mon, 8 Jan 2001 09:46:01 -0600
>To: "Frank M. Betz, Jr." <fbetz@stripped>,
><win32@stripped>
>From: Paul DuBois <paul@stripped>
>Subject: Re: SQL...
>
>> At 12:11 AM -0500 1/8/01, Frank M. Betz, Jr. wrote:
>> >if that works that's unbelievable. I always thought you could only
>> >move data from table to table from the same database not from two
>> >different ones. How do you establish a connection to two at the same
>> >time through straight SQL?
>>
>> You can access multiple databases on the same server if you qualify
>> table names as necessary with leading database names (e.g.,
>> db_name.tbl_name). You can't access databases on different servers
>> within the same statement.
>>
>> >
>> >----- Original Message -----
>> >From: Nyström, Rasmus <rasmus.nystrom@stripped>
>> >To: 'jed' <webmaster@stripped>
>> >Cc: WinMySQL <win32@stripped>
>> >Sent: Sunday, January 07, 2001 11:42 AM
>> >Subject: RE: SQL...
>> >
>> >
>> >> If I'm not entierly wrong that "exact" would do the trick
>> >>
>> >>
>> >http://www.mysql.com/documentation/mysql/commented/manual.php?section
>> >=INSERT
>> >>
>> >>
>> >> /Rasmus
>> >>
>> >> -----Original Message-----
>> >> From: jed [mailto:webmaster@stripped]
>> >> Sent: den 7 januari 2001 11:21
>> >> Cc: WinMySQL
>> >> Subject: SQL...
>> >>
>> >>
>> >>
>> >> Hi @,
>> >> one question,
>> >>
>> >> Is there any possibility to transfer the data from one table of
>> >> one
>> >database
>> >> to another table of another database...
>> >>
>> >> I'll try to be creativ.... :-)
>> >>
>> >> insert into database1.table1 select * from database2.table2....
>> >>
>> >> or something like this...
>> >>
>> >> Any Ideas?
>> >>
>> >> Regards
>> > > jed
>>
>>
>> --
>> Paul DuBois, paul@stripped
>>
>> ---------------------------------------------------------------------
>> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html"
>> before posting. To request this thread, e-mail
>> win32-thread4720@stripped
>>
>> To unsubscribe, send a message to the address shown in the
>> List-Unsubscribe header of this message. If you cannot see it,
>> e-mail win32-unsubscribe@stripped instead.
>>
>
>
>==============================
>Facilities Management
>Webmaster
>Computer Programmer
>Desktop, Software Support
>==============================
>Nick Tentomas
>Space Planning
>Dalhousie University
>Central Services Building
>1236 Henry Street
>Halifax, Nova Scotia
>B3H 3J5
>C A N A D A
>
>==============================
>
>Facilities Management Home Page
>
>http://www.dal.ca/ppp/
>
>==============================
>
>Tel. : 902-494-2251
>Fax. : 902-494-1645
>
>
>Nick.Tentomas@stripped
--
Paul DuBois, paul@stripped
