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 <[email protected]> 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:[email protected]] > Sent: Friday, August 27, 2010 12:57 PM > To: [email protected] > 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/[email protected] > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[email protected] > > -- - michael dykman - [email protected] May the Source be with you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[email protected]
