How to use GROUP_CONCAT in a CONCAT in MySQL

by 
select id, group_concat(`Name` separator ',') as `ColumnName`
from
(
  select 
    id, 
    concat(`Name`, ':', group_concat(`Value` separator ',')) as `Name`
  from mytbl
  group by 
    id, 
    `Name`
) tbl
group by id;

You can see it implemented here : Sql Fiddle Demo. Exactly what you need.

Update
Splitting in two steps. First we get a table having all values(comma separated) against a unique[Name,id]. Then from obtained table we get all names and values as a single value against each unique id
See this explained here SQL Fiddle Demo (scroll down as it has two result sets)

Edit There was a mistake in reading question, I had grouped only by id. But two group_contacts are needed if (Values are to be concatenated grouped by Name and id and then over all by id). Previous answer was

select 
id,group_concat(concat(`name`,':',`value`) separator ',')
as Result from mytbl group by id

You can see it implemented here : SQL Fiddle Demo

More Related Contents:

  1. Can I concatenate multiple MySQL rows into one field?
  2. MySQL and GROUP_CONCAT() maximum length
  3. Strange duplicate behavior from GROUP_CONCAT of two LEFT JOINs of GROUP_BYs
  4. What is the opposite of GROUP_CONCAT in MySQL?
  5. String concatenation in MySQL
  6. MySQL DISTINCT on a GROUP_CONCAT()
  7. GROUP_CONCAT ORDER BY
  8. GROUP_CONCAT with limit
  9. MySQL: Sort GROUP_CONCAT values
  10. MySQL select with CONCAT condition
  11. How create json format with group-concat mysql?
  12. MySQL concat() to create column names to be used in a query?
  13. How to hack MySQL GROUP_CONCAT to fetch a limited number of rows?
  14. GROUP_CONCAT equivalent in Django
  15. MySQL CONCAT returns NULL if any field contain NULL
  16. is there a length limit to group_concat or another reason why it would not work on a text field
  17. Trouble with GROUP_CONCAT and Longtext in MySQL
  18. NOT LIKE not working with SHOW [duplicate]
  19. MySQL Error 1093 – Can’t specify target table for update in FROM clause
  20. How to define a custom ORDER BY order in mySQL
  21. MySQL Orderby a number, Nulls last
  22. Troubleshooting “Illegal mix of collations” error in mysql
  23. How to remove leading and trailing whitespace in a MySQL field?
  24. How to reset the root password in MySQL 8.0.11?
  25. What characters have to be escaped to prevent (My)SQL injections?
  26. How to save MySQL query output to excel or .txt file? [duplicate]
  27. NodeJS responded MySQL timezone is different when I fetch directly from MySQL
  28. How to swap values of two rows in MySQL without violating unique constraint?
  29. SQL date format convert? [dd.mm.yy to YYYY-MM-DD]
  30. GRANT with database name wildcard in MySQL?

Leave a Comment