Search for "aliases" in manual.html. PB
----- ----- Original Message ----- From: "Phillip Rhodes" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > --------------------------------------------------------------------- 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