Member Avatar for saadi06

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

  • 2 Contributors
  • 3 Replies
  • 106 Views
  • 36 Minutes Discussion Span
  • Latest Post Latest Post by blocblue
Member Avatar for blocblue

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

SELECT a, b, c, 'my value' as d from table;
Member Avatar for saadi06

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

Member Avatar for blocblue

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.