select query into list on one column

Question

I am trying to select all id into one column and delimit it with a comma ,

My DATA column:

+---+--------+--------------+
|id |somedata|someother data|
+---+--------+--------------+
|1  |data1   |other1        |
+---+--------+--------------+
|2  |data2   |other2        |
+---+--------+--------------+
|3  |data3   |other3        |
+---+--------+--------------+

The result I am trying to make:

+-------+
|id list|
+-------+
|1, 2, 3|
+-------+

The result should be a list of ID's in 1 column named 'id list'.

The question is, is this possible? and how? I tried searching for the keywords sql query select into list and other keywords but with no luck.

But this query is on a nested select.

A question like this has been asked and answered a thousand times before. — Rachcha
– Rachcha, Commented Jan 13, 2014 at 5:22

Saharsh Shah · Accepted Answer · 2014-01-13 05:20:40Z

5

Use GROUP_CONCAT():

SELECT GROUP_CONCAT(id) AS idList FROM tableA

answered Jan 13, 2014 at 5:20

Saharsh Shah

29.1k9 gold badges53 silver badges85 bronze badges

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

2 Comments

majidarif Over a year ago

I'm getting syntax error on INTO. (edit) oh, I changed into to AS and it works. thanks.

majidarif Over a year ago

I got it. It seemed weird to have the into in there. but I'm getting only the last id, example 3 ids in there the result is 3,3,3 instead of 1,2,3.. And on another note that query is on a nested select.

Collectives™ on Stack Overflow

select query into list on one column

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related