[kwlug-disc] [OT] how to create a mysql table alias in the db itself?

Robert P. J. Day rpjday at crashcourse.ca
Tue Mar 9 13:40:47 EST 2010

  i have a bunch of mysql queries from two different sources, and they
purport to work on the same database but they access the same table by
two different names.  can i add a simple alias to the database for
just that one table?

  i know i can add an alias to the queries themselves but there are
hundreds of them and that would be painful.  i also see something
called "views" which might work.  but is there a canonical way to
simply add an alternative name for an existing table within the
database itself so that all the existing queries don't need to be
munged?  thanks.


Robert P. J. Day                               Waterloo, Ontario, CANADA

            Linux Consulting, Training and Kernel Pedantry.

Web page:                                          http://crashcourse.ca
Twitter:                                       http://twitter.com/rpjday

More information about the kwlug-disc mailing list