Re: Aliasing all fields

[Paul DuBois]

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
>
>--
>z, admin@stripped on 09/18/2002