List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:September 19 2002 3:03am
Subject:Re: Aliasing all fields
View as plain text  
At 19:51 -0700 9/18/02, z wrote:
>On Wed, 18 Sep 2002 22:45:29 -0400, 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
>would select table1.*,table2.* from
>do that?

No.  MySQL displays just the column names in this case, not names
in tbl_name.col_name format.

>z, admin@stripped on 09/18/2002

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