]]> ]]>

The power of MySQL's GROUP_CONCAT

You are here

May, 2014

MySQL has useful extension to the GROUP BY operation: function GROUP_CONCAT:

GROUP_CONCAT(expr) – This function returns a string result with the concatenated non-NULL values from a group.

When is GROUP_CONCAT useful? Usually while working with Support customers I recommend it when you have aggregation of many-to-many info. It makes the view simpler and more beautiful and it doesn’t need much effort to make it work.

In the Percona eBook, "The power of MySQL’s GROUP_CONCAT,” authors Vadim Tkachenko and Michael Rikmas provide real-world examples of GROUP_CONCAT in action.

Stored Under: Percona Server

Authors

Michael Rikmas

Michael Rikmas

Support engineer

Michael joined Percona in October 2007. He serves in several roles, including Wikimaster and company schedules administrator. In the latter role, he is involved in assuring Percona's 24x7 support coverage. He was also the organizer of the company's first two annual all-staff meetings. He is working now in Support team as Support Engineer. Prior to joining the company, Michael worked as a consultant on Enterprise Resource Planning and Customer Relationship Management systems. His introduction to computers was in 2000, when he began his university studies.


Vadim Tkachenko

Vadim Tkachenko

CTO

Vadim leads Percona's Development group which produces the Percona Server, Percona XtraDB, and Percona XtraBackup. He is an expert in LAMP performance, especially optimizing MySQL and InnoDB internals to take full advantage of modern hardware using his multi-threaded programming background. Source code patches authored by Vadim have been incorporated by Oracle Corporation and its predecessors into the mainstream MySQL and InnoDB products. At Percona, Vadim also designs no-gimmicks benchmark tests of hardware, filesystems, storage engines, and databases.



Contact Us 24 Hours A Day
Support Contact us 24×7
Emergency? Contact us for help now!
Sales North America (888) 316-9775 or
(208) 473-2904
Sales
Europe
+44-208-133-0309 (UK)
0-800-051-8984 (UK)
0-800-181-0665 (GER)
Training (855) 55TRAIN or
(925) 271-5054

 

Share This
]]>