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?
----- 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
>
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail win32-thread4715@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.
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail win32-thread4716@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.
>
>
