List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:September 19 2002 2:58am
Subject:Re: Aliasing all fields
View as plain text  
At 22:45 -0400 9/18/02, Rob Hutton wrote:
>Is there a way to get MYSQL to alias all fields in a select even if there is
>no naming conflict?  For instance, if I do a:
>
>select * from table1, table2 where table1.t1c1 = table2.t2c2
>
>then I want
>
>table1.t1c1 | table1.t1c2 | table1.t1c3 | table2.t2c1 | table2.t2c2
>
>Not just the column names.

You'll need to specify the names you want displayed explicitly.

>
>Thanks,
>Rob Hutton
>Web Safe
>www.wsafe.com

Thread
Aliasing all fieldsRob Hutton19 Sep
  • Re: Aliasing all fieldsz19 Sep
  • Re: Aliasing all fieldsPaul DuBois19 Sep
Re: Aliasing all fieldsPaul DuBois19 Sep
Re: Aliasing all fieldsxuefer tinys19 Sep
  • RE: Aliasing all fieldsRob Hutton19 Sep