I don't know, it could simply be possible,
that it works... :-)
So well, I did it another way, just with one frontend....
thanx
regards
jed
"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?
>
> ----- 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.
> >
> >
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail win32-thread4717@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.
