about it. (I'd be interested too, just for curiousity's sake.)
>
> Rhino
> - Original Message -
> From: <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Cc: "Gleb Paharenko" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
>
he would love to hear
about it. (I'd be interested too, just for curiousity's sake.)
Rhino
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: "Gleb Paharenko" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
"MySql List"
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 dynamica
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
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.
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 'Total
