List:General Discussion« Previous MessageNext Message »
From:Peter Brawley Date:November 13 2002 1:47pm
Subject:Re: support table synonyms?
View as plain text  
Search for "aliases" in manual.html.

PB

-----


----- Original Message -----
From: "Phillip Rhodes" <rhodespc@stripped>
To: <mysql@stripped>
Sent: Tuesday, November 12, 2002 8:59 PM
Subject: support table synonyms?


>
> I can not find anywhere that says that mysql supports table name synonyms.
>
> For example, I have two databases (test1 and test2) in the same mysql
instance.
>
> In test1 schema, there is a table called "table1"
>
> I would like to create a synonym whereby I could refer to test1.table1 as
> test2.table1 where test2.table1 does not exist.
>
> I could do this in oracle as ..
> create public synonym table1 as test1.table1;
>
>
> Thanks!
>
>
> ---------------------------------------------------------------------
> 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 <mysql-thread124834@stripped>
> To unsubscribe, e-mail
<mysql-unsubscribe-peter.brawley=artfulsoftware.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>


Thread
support table synonyms?Phillip Rhodes13 Nov
  • Re: support table synonyms?R. Hannes Niedner13 Nov
  • Re: support table synonyms?Dan Nelson13 Nov
  • Re: support table synonyms?Peter Brawley13 Nov