var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Beginners question Aliased Columns
Hi I'm having trouble in referring to an aliased column name in my query.
SELECT 1 as v1, v1+1 as v2;
Can anyone tell me how to do this please?
Re: Beginners question Aliased Columns
Try this instead:
This will assign the user variable @v1 the value of v1 for each record. I am not sure why you cannot refer to aliased columns within the column selection portion of the statement.
SELECT @v1:=1 as v1, @v1+1 as v2;