MySQL Forums
Forum List  »  Newbie

Re: Select statement including column headings
Posted by: Phillip Ward
Date: November 15, 2019 05:43AM

Quote

... select data ... including the table's column headings ...

Why would you need to?

You should always specify the columns that you are retrieving in your select statements, so you already know what the column headings are ...

select field1 
,      field2 as "Name"
,      field3 
from table4 
order by field1
, field2 
;

Regards, Phill W.

Options: ReplyQuote


Subject
Written By
Posted
Re: Select statement including column headings
November 15, 2019 05:43AM


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.