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
