MySQL Forums :: Newbie :: multiple rows into one line string with


Advanced Search

multiple rows into one line string with
Posted by: Agustian Mochammad ()
Date: July 16, 2009 10:28PM

Hi All,

Could you help me in mysql how to query table with multiple rows and result in one string (with delimeter). Let say I've table
Table A
col1
1
2
3
4
5
6
7
8

the query result from table a is :
result
1,2,3,4,5,6,7,8

Please help me.

Options: ReplyQuote


Subject Written By Posted
multiple rows into one line string with Agustian Mochammad 07/16/2009 10:28PM
Re: multiple rows into one line string with Umesh Shastry 07/17/2009 01:55AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.