Re: set the value of AS clause name in stored procedure

[Terry Warren]

Peter Brawley Wrote:
-------------------------------------------------------
> Simplest possible example given table t(i,j)...
>
>

> set @sql = "select i as 'first column',j as
> 'second column' from t";
> prepare stmt from @sql;
> execute stmt;
> +--------------+---------------+
> | first column | second column |
> +--------------+---------------+
> |            2 |             2 |
> +--------------+---------------+
> drop prepare stmt;
>

>
> In your case you'd concat strings as required to
> assemble @sql.

thanks for this added response; using this technique I was able to do exactly what I wanted to. thanks again.