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
http://www.mysql.com/doc/en/Symbolic_links.html and
http://www.mysql.com/doc/en/Symbolic_links_to_tables.html for
instructions and caveats.
--
Dan Nelson
dnelson@stripped
