MySQL multiple row literal select [duplicate]

Question

Possible Duplicate:
Can you define “literal” tables in SQL?

Occasionally I find myself in a situation where I'd like to join an existing table to a table of values that are entered in the query. Something like:

SELECT ((1,2,3),(4,5,6));

Where the query would return two rows of 3 columns. Obviously this syntax is not correct, but it is possible to generate a single row of data in this way. For example:

SELECT 1,2,3;

Is there actually a way to do what I'm trying to achieve?

gbn · Accepted Answer · 2011-10-28 10:39:30Z

11

SELECT 1,2,3
UNION ALL
SELECT 4,5,6;

answered Oct 28, 2011 at 10:39

gbn

434k84 gold badges602 silver badges690 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

andrewmabbott Over a year ago

Brilliant, thanks. I was hoping it would be more elegant but it works! I can use it combination with this stackoverflow.com/questions/1764881/… to generate histogram data without needing to create an extra table.

Ubeogesh Over a year ago

is there a way to name the columns in this, without specifying the same "AS column1"... in each line?

Romain Hautefeuille Over a year ago

yes just give names to the first select : select 2 as id, 3 as code union all select 1, 4

Collectives™ on Stack Overflow

MySQL multiple row literal select [duplicate]

1 Answer 1

3 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Linked

Related