MySQL Forums
Forum List  »  Newbie

How to add a Constant Field in Select Query Result Set ?
Posted by: Laxmilal Menaria
Date: September 15, 2008 11:34PM

Hello,

I have created a Table "Personal" fields like ID, Name, Address.
Now want to List all values so run this "Select * from Personal", its shows me all rows, but I want the result type like...

ID Name Address type
1 Laxmilal udaipur PersonalData
2 Maohan Udaipur PersonalData

Need to add PersonalData constant in result set, I don't want to add new column in table, so how can I do that ?

Please let me know..

Thanks in advance,
Laxmilal

Options: ReplyQuote


Subject
Written By
Posted
How to add a Constant Field in Select Query Result Set ?
September 15, 2008 11:34PM


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.