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
