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

Raul Suarez 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.

Raul Suarez

Technology consultant
Software, Hardware and Practices
_________________
http://rarsa.blogspot.com/ 
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
> 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
> ========================================================================
> 
> _______________________________________________
> kwlug-disc_kwlug.org mailing list
> kwlug-disc_kwlug.org at kwlug.org
> http://astoria.ccjclearline.com/mailman/listinfo/kwlug-disc_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_kwlug.org mailing list