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, [EMAIL PROTECTED] on 09/18/2002 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
