How to Convert comma separated string to rows in mysql,stuff function equivalent in mysql

How to Converting Rows to Comma Separated Values.
Answer

Converting Rows to Comma Separated Values,
stuff function equivalent group_concat in mysql.

SELECT:
select country from country
RESULT:

The GROUP_CONCAT() function.
SELECT GROUP_CONCAT(country) As country FROM country 

RESULT:

Post a Comment

0 Comments