Re: dynamic alias?

2010-08-27 Thread Peter Brawley
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

RE: dynamic alias?

2010-08-27 Thread Steven Staples
DATE_ADD(NOW(), INTERVAL 1 DAY) will give you tomorrow... Not sure if that is what you're looking for or not... Steven Staples -Original Message- From: Eric Bloomquist [mailto:eric_bloomqu...@cooley-dickinson.org] Sent: August 27, 2010 12:17 PM To: mysql@lists.mysql.com Subject:

RE: dynamic alias?

2010-08-27 Thread Eric Bloomquist
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

Re: dynamic alias?

2010-08-27 Thread Michael Dykman
: 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