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.
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
