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
