semi OT : SQL syntax question

[Trevor DeVore]

On Jun 29, 2005, at 8:47 AM, jbv wrote:

> Trevor,
>
> Thanks, but I found the solution in the mySQL manual
> about an hour ago... I was actually confusing the Postgres
> and mySQL syntax... stupid me...
>
> However, why did you add "as myCol" ?
>
> I'm using :
> SELECT concat("$",ID,"$"), col_1, col_2 FROM myTable WHERE
> id < 100

If you are going to be dealing with your columns by name when working  
with the results then myCol is easier to write than concat 
("$",ID,"$") which is what the column would be named without the "as  
myCol".

-- 
Trevor DeVore
Blue Mango Multimedia
trevor at mangomultimedia.com