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

Recommended Answers

All 3 Replies

Yes. Just specify the value for d. E.g.

SELECT a, b, c, 'my value' as d from table;

Thanks a lot blockblue you saved my life my problem is solved

Thanks for marking the thread as solved.

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.