[kwlug-disc] [OT] how to create a mysql table alias in the db itself?
rarsa at yahoo.com
Tue Mar 9 14:39:18 EST 2010
Before getting to the second paragraph I thought "Views".
That would be a simple way of doing it.
Software, Hardware and Practices
An eclectic collection of random thoughts
--- On Tue, 3/9/10, Robert P. J. Day <rpjday at crashcourse.ca> wrote:
> From: Robert P. J. Day <rpjday at crashcourse.ca>
> Subject: [kwlug-disc] [OT] how to create a mysql table alias in the db itself?
> To: "KWLUG discussion list" <kwlug-disc at kwlug.org>
> Received: Tuesday, March 9, 2010, 1:40 PM
> 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
> 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:
> kwlug-disc_kwlug.org mailing list
> kwlug-disc_kwlug.org at kwlug.org
Ask a question on any topic and get answers from real people. Go to Yahoo! Answers and share what you know at http://ca.answers.yahoo.com
More information about the kwlug-disc