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 [EMAIL PROTECTED] --------------------------------------------------------------------- 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