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
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
>> -----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
>> 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?
> > jed
Paul DuBois, paul@stripped