It would be easiest if you showed us the query you are using but the simple column alias has been in MySQL since v2
SELECT foo, count(*) bar AS mycount FROM... In keeping with SQL practice, the 'AS' keyword is optional but it does make it easier to see the syntax. This is equivalent: SELECT foo, count(*) bar mycount FROM... - michael dykman On Fri, Aug 27, 2010 at 2:59 PM, Eric Bloomquist <eric_bloomqu...@cooley-dickinson.org> wrote: > Thanks, PREPARE certainly has some potential. > > Unfortunately, when I try to use that sort of thing inside of a Cognos > report, it complains that "At least one expression in the Select clause > is missing the AS clause to make it a proper alias." > > (Sorry I didn't include the Cognos context -- it didn't occur to me that > it'd be relevant.) > > Thanks, > Eric > > > -----Original Message----- > From: Peter Brawley [mailto:peter.braw...@earthlink.net] > Sent: Friday, August 27, 2010 12:57 PM > To: mysql@lists.mysql.com > Subject: Re: dynamic alias? > > On 8/27/2010 11:16 AM, Eric Bloomquist wrote: >> Hi all, >> >> I'm wondering if it's possible to have a dynamic alias in MySQL. The >> result I'm looking for is essentially: > See the manual page for PREPARE. > > PB > > ----- >> +-----------------+---------------------------+--------------------+ >> | Provider Name | Facility Name | Appts on 8/28/2010 > |<== >> +-----------------+---------------------------+--------------------+ >> | Mildred Ratched | Oregon State Hospital | 12 | >> | Henry Jekyll | London Internal Medicine | 3 | >> | ... | | | >> >> Where "Appts on 8/28/2010" instead includes whatever tomorrow's date > is >> when the query is run. >> >> Is it possible to do something like this in a MySQL query? >> >> Thanks, >> Eric >> >> > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=eric_bloomqu...@cooley-dickinson.org > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=mdyk...@gmail.com > > -- - michael dykman - mdyk...@gmail.com May the Source be with you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
