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_Bloomquist@stripped> 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.brawley@stripped]
> Sent: Friday, August 27, 2010 12:57 PM
> To: mysql@stripped
> 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=1
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
>
>
--
- michael dykman
- mdykman@stripped
May the Source be with you.
