MySQL Forums
Forum List  »  General

Re: i'm amazed by the UNLOGICAL 'AS' command
Posted by: Harrison Fisk
Date: October 10, 2004 05:24PM

Hi,

Unfortunately this is part of the ANSI SQL specification to return just the column name, and the the table name as well. You will find that all databases should react this same way. So you are stuck alias'ing the columns with AS if you want to have a different name then the default. Most API's also offer a way to access data by the column offset, such as 1 or 2 in your above case, rather than the name.

Regards,

Harrison

Options: ReplyQuote


Subject
Written By
Posted
Re: i'm amazed by the UNLOGICAL 'AS' command
October 10, 2004 05:24PM


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.