support table synonyms?

[Phillip Rhodes]

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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php