How to create virtual column with multiple value using MySQL SELECT?

Question

I can add virtual columns as

SELECT '1' as id

| id |
-------
|  1 |

But I want add multiple values, example:

SELECT ('1','2','3') as id

| id |
-------
|  1 | 
|  2 | 
|  3 |

But this don't work

you can't have a single query split a single row into multiple rows, but you can have multiple queries, each producing one of the values, by chaining them together with union. — Marc B
– Marc B, Commented Mar 12, 2015 at 16:25

jpw · Accepted Answer · 2015-03-12 18:17:31Z

0

Like Marc B said in a comment you can't have a single query split a single row into multiple rows, but you can have multiple queries, each producing one of the values, by chaining them together with union.

SELECT 1 id 
UNION 
SELECT 2 
UNION 
SELECT 3

As the answer was provided in a couple of comments I'll post it as a community wiki.

Collectives™ on Stack Overflow

How to create virtual column with multiple value using MySQL SELECT?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related