query to get all the values of a particular column in a table(using comma seperator) into string type array

Question

0.00/5 (No votes)

See more:

Hi Good Evening

My doubt is i have a table called userinfo in my database with one of the column as SenderId.Now i want to get all the values of the SenderId column into a string type array using comma seperator.Can you please tell me how to write the query for this in mysql.

Thanks in advance

Posted 18-Jul-11 0:40am

komali Guntur

Add a Solution

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Shameel · Answer 1 · 2011-07-18T00:54:00

Solution 2

SQL

DECLARE @Output varchar(max) = ''
SELECT @Output = coalesce(@Output+',','') + CONVERT(varchar(max),Col1) FROM Table1
SET @Output = RIGHT(@Output,LEN(@Output)-1)
PRINT @Output

Posted 18-Jul-11 0:54am

Shameel

Comments

Manas Bhardwaj 18-Jul-11 7:02am

Correct, but this is more T-Sql way of doing. In MySQL, you can do it with GROUP_CONCAT function. See my answer.
Anyways, +5. :)

[no name] 18-Jul-11 7:41am

Thanks :)

Manas Bhardwaj · Answer 2 · 2011-07-18T00:56:00

Solution 3

like this:

SELECT GROUP_CONCAT(SenderID) FROM UserInfo

Posted 18-Jul-11 0:56am

Manas Bhardwaj

Comments

OriginalGriff 18-Jul-11 7:08am

Nice solution - simple and effective. :thumbsup:

Manas Bhardwaj 18-Jul-11 7:09am

thanks :)

komali Guntur 18-Jul-11 7:19am

Thank You Bhardwaj with this query i am getting the comma seperated values when i execute the query through the query browser in mysql.But when i kept the same query in my code i am getting the exception as org.hibernate.MappingException: No Dialect mapping for JDBC type: -1. My code is like this

session = HibernateSessionFactory.getSession();

String hql = "select GROUP_CONCAT(SenderId) FROM userinfo";

senderIdValue = (String)session.createSQLQuery(hql).list().get(0);

Can you give me any idea about this exception.

query to get all the values of a particular column in a table(using comma seperator) into string type array

2 solutions

Solution 2

Solution 3

Add your solution here

Preview 0

query to get all the values of a particular column in a table(using comma seperator) into string type array

2 solutions

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us