Yep Jermey are right what he says - Anyone know about using Database link in Mysql???
Regards Frank ----- Original Message ----- From: "Jeremy Zawodny" <[EMAIL PROTECTED]> To: "Egor Egorov" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, January 20, 2003 4:35 PM Subject: Re: Mysql and Database Link > On Mon, Jan 20, 2003 at 03:49:00PM +0200, Egor Egorov wrote: > > On Monday 20 January 2003 06:36, MySQL wrote: > > > > > I'm woundering if Mysql can use Database link, like Oracle can??? > > > > > > Eg. If i have some tables at my labtop, and want to make the same table(s) > > > at my server with this command: > > > > > > create table test as select * from test@database_link (This is how you do > > > it on Oracle), but how do I do this in Mysql???? > > > > You can use CREATE .. SELECT statement: > > http://www.mysql.com/doc/en/CREATE_TABLE.html > > > > but you must create indexes manually. > > I think you misunderstand. Those are not really the same. Links in > Oracle (as described to me) allow you to connect multiple servers > together--so you can join between tables on different servers, for > example. > > Jeremy > -- > Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! > <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ > > MySQL 4.0.8: up 1 days, processed 46,297,176 queries (320/sec. avg) > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php