MyGroupConcat v2.1.1


Author: Emmanuel KARTMANN.

Last Update: January 7th, 2004


OVERVIEW

This MySQL extension library provides an aggregate function that concatenate strings (for use with SELECT...GROUP BY clause).


CONTENTS


COMPONENT FEATURES

This component:


USAGE

To use this component from MySQL:


SAMPLE CODE (SQL)

Create test data

Display group_concat() output only

Display group_concat() and value of GROUP BY clause

Display group_concat(), value of GROUP BY clause, and use separator

Display group_concat(), value of GROUP BY clause, use separator and start from given count

Display group_concat(), value of GROUP BY clause, use separator, start from given count and end before given count


IMPLEMENTATION


TO DO LIST


Download

Download Article and Source Code (65 KB).

Download self-extracting setup (691 KB).