Hi,
I have a problem in making a query to make virtual columns in my query. I want to make a query that makes virtual column. for example I have a table with columns a,b and c and I want to make a query something like this
SELECT a as acolumn,b as b column,c as ccolumn,d as doesnotexist in table. and the d column does not select anything but it displays as a column. Is this possible in mysql.
Thanks in advance
saadi06
2
Junior Poster in Training
Recommended Answers
Jump to PostYes. Just specify the value for d. E.g.
SELECT a, b, c, 'my value' as d from table;
All 3 Replies
blocblue
238
Posting Pro in Training
Featured Poster
saadi06
2
Junior Poster in Training
blocblue
238
Posting Pro in Training
Featured Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.