sql 쿼리된 리스트(테이블 컬럼들)을 하나로 합치기 ,

select query into list on one column

[Q] 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.

경축! 아무것도 안하여 에스천사게임즈가 새로운 모습으로 재오픈 하였습니다.
어린이용이며, 설치가 필요없는 브라우저 게임입니다.
https://s1004games.com

But this query is on a nested select.

[A] Use GROUP_CONCAT():

SELECT GROUP_CONCAT(id) AS idList FROM tableA

[출처] https://stackoverflow.com/questions/21084354/select-query-into-list-on-one-column