concat()<\/a> function. Here is an example to concatenate all values of attribute as well as id columns.<\/p>\n\n\n\nmysql> SELECT GROUP_CONCAT( attributes SEPARATOR ' ') as \"id : attributes\"
FROM (
SELECT id, CONCAT ( name, ':', GROUP_CONCAT(attribute SEPARATOR', ') )
as \"attributes\"
FROM product
GROUP BY name
) as emp;
+-------------------------------------------------------------------------------+
| id : attributes |
+-------------------------------------------------------------------------------+
| A:strong, durable, attractive, strong B:cheap, waterproof, attractive, cheap |
+-------------------------------------------------------------------------------+<\/pre>\n\n\n\nIn the above query, there are 2 SQL queries. The inner SQL query does a concatenation of attribute column as well as product name column.<\/p>\n\n\n\n
mysql> SELECT id, CONCAT ( name, ':', GROUP_CONCAT(attribute SEPARATOR', ') )
as \"attributes\"
FROM product
GROUP BY name ;
+------+----------------------------------------+
| id | attributes |
+------+----------------------------------------+
| 1 | A:strong, durable, attractive, strong |
| 2 | B:cheap, waterproof, attractive, cheap |
+------+----------------------------------------+<\/pre>\n\n\n\nThe outer SQL query concatenates the values of attributes column.<\/p>\n\n\n\n
+-------------------------------------------------------------------------------+
| id : attributes |
+-------------------------------------------------------------------------------+
| A:strong, durable, attractive, strong B:cheap, waterproof, attractive, cheap |
+-------------------------------------------------------------------------------+<\/pre>\n\n\n\nWe have used a very simple example in this case for ease of understanding. You can obviously use group by clause in outer SQL query to concatenate values for each group.<\/p>\n\n\n\n