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

Terrence Enger tenger at iseries-guru.com
Tue Mar 9 14:51:27 EST 2010


On Tue, 2010-03-09 at 11:39 -0800, Raul Suarez wrote:
> 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?

With syntax from DB2 again,

    create alias newname for existingtable

HTH,
Terry.


> > 
> >   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
> 
> _______________________________________________
> kwlug-disc_kwlug.org mailing list
> kwlug-disc_kwlug.org at kwlug.org
> http://astoria.ccjclearline.com/mailman/listinfo/kwlug-disc_kwlug.org




More information about the kwlug-disc_kwlug.org mailing list