[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.

rday
--

========================================================================
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_kwlug.org mailing list