I am getting this output in mysql query.(which has key value pairs)
-id NAME VALUE
--1 customerName Narendra
--1 customerCountry India
How we can convert this to (single line)
id customerName country
1 Narendra India
Asked
Active
Viewed 51 times
0
manish
- 61
- 1
- 1
- 12
-
have a look there http://stackoverflow.com/questions/7674786/mysql-pivot-table – Raphael Müller Nov 17 '14 at 10:16
-
`SELECT Id,GROUP_CONCAT(VALUE ORDER BY NAME DESC) FROM t GROUP BY Id` – Mihai Nov 17 '14 at 10:16
-
@Mihai please note that with `GROUP_CONCAT` the values are in the same field in the resultset, e.g. you need a separator and process the result later on. – Raphael Müller Nov 17 '14 at 10:19
-
http://stackoverflow.com/questions/1164350/retrieving-a-row-with-data-from-key-value-pair-table-in-mysql – manish Nov 19 '14 at 08:31
-
http://stackoverflow.com/questions/1164350/retrieving-a-row-with-data-from-key-value-pair-table-in-mysql – manish Nov 19 '14 at 08:32