MySQL Forums
Forum List  »  Newbie

Re: mysql question
Posted by: Phillip Ward
Date: September 18, 2014 05:57AM

In what context?
If you're selecting data, you can add aliases to any column:

select   field1  a 
,        field2  b 
,        field3  c 
from     table1  t1 
order by 1 ; 

+-----+-----+-----+ 
| a   | b   | c   | 
+-----+-----+-----+ 
|   0 |   1 |   2 | 
|  11 |  22 |  33 | 
| 222 | 333 | 444 | 
 . . . 

Options: ReplyQuote


Subject
Written By
Posted
September 18, 2014 05:03AM
Re: mysql question
September 18, 2014 05:57AM
September 18, 2014 06:09AM
September 19, 2014 12:36AM
September 19, 2014 07:02PM
September 30, 2014 05:03AM
September 18, 2014 11:00AM


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.