List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:November 13 2002 6:46am
Subject:Re: support table synonyms?
View as plain text  
In the last episode (Nov 12), Phillip Rhodes said:
> 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.

You can use symlinks to do this.  See and for
instructions and caveats.

	Dan Nelson
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