MySQL Forums
Forum List  »  General

i'm amazed by the UNLOGICAL 'AS' command
Posted by: olivier Hericord
Date: October 10, 2004 10:44AM


i'm using MySQL for years and i'm amazed i always have to populate my queries with such things:

select as tb1_name, as tb2_name from tbl1,tbl2 where .......

In my mind , most of the time my table is my object and my field is my Method like in OOP!!!!!

it's amazing that i can't write select * from tbl1, tbl2 where ..... and being abble to browse the result and being able to fetch and !!!!!!!!!!!!!!!!!!!!!!!!!!!!!

in the terminal such a querie gives 2 colums entitled 'name'......WHAT THE HELL!!!!!!!!! why these colums are not entitled '' and ''???????????????

i can't understand such a limitation

Options: ReplyQuote

Written By
i'm amazed by the UNLOGICAL 'AS' command
October 10, 2004 10:44AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.