Hello, Mauricio.
I've found something in comments at:
http://dev.mysql.com/doc/mysql/en/Problems_with_alias.html
But I don't know if that will help you. Here it is:
Posted by Ravi Kumar on November 10 2004 9:21am
The above tip can be extended to have variables in column names.
Thanks Gleb, but I cant use that because the query is run directly from
within an aplication.
Of course there're should other ways to do that but I want to know if
it is posible from within MySql 4.1 gamma.
If someone does know the answer to this question please let me know
Just in case someone
If what you are looking for is a way to say:
SET @columnName='mycolumn';
SELECT @columnName FROM mytable;
and have it be interpreted as the same query as:
SELECT mycolumn FROM mytable;
Then you are out of luck. However, nothing says you can't build a SQL
statement in your application
, just for curiousity's sake.)
Rhino
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: Gleb Paharenko [EMAIL PROTECTED]; [EMAIL PROTECTED];
MySql List [EMAIL PROTECTED]
Sent: Tuesday, November 16, 2004 1:47 PM
Subject: Re: Naming columns dynamically
If what you
: Gleb Paharenko [EMAIL PROTECTED]; [EMAIL PROTECTED];
MySql List [EMAIL PROTECTED]
Sent: Tuesday, November 16, 2004 1:47 PM
Subject: Re: Naming columns dynamically
If what you are looking for is a way to say:
SET @columnName='mycolumn';
SELECT @columnName FROM mytable;
and have
Hi ,
I need to do the following:
Given a certain variable for example @var I want to include the
contents of that variable as part of the name of a result column.
I'll try to explain myself a bit more with this example
Set @var = 'October_' ;
Select
Tot as