Skip navigation links

MySQL Forums :: Newbie :: How to add a Constant Field in Select Query Result Set ?


Advanced Search

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 ? Laxmilal Menaria 09/15/2008 11:34PM
Re: How to add a Constant Field in Select Query Result Set ? Tej Kiran Sharma 09/16/2008 12:33AM
Re: How to add a Constant Field in Select Query Result Set ? Aleksandar Kordic 12/01/2008 06:39AM


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.