GROUP_CONCAT()

Overview

A description for this Function has not yet been added to this Documentation.

See also: Functions in 10.6 ES, in 10.5 ES, and in 10.4 ES

EXAMPLES

CREATE TABLE t (a INT, b INT);
INSERT INTO t VALUES
  (1,3), (1,5), (8,2), (5,7), (5,6),
  (10,1), (6,4), (3,9), (3,9), (7,2),
  (7,5), (2,6), (9,10), (9,5), (4,8);
SELECT GROUP_CONCAT(DISTINCT a), GROUP_CONCAT(DISTINCT b) FROM t;
+--------------------------+--------------------------+
| GROUP_CONCAT(DISTINCT a) | GROUP_CONCAT(DISTINCT b) |
+--------------------------+--------------------------+
| 1,2,3,4,5,6,7,8,9,10     | 1,2,3,4,5,6,7,8,9,10     |
+--------------------------+--------------------------+

CHANGE HISTORY

Release Series

History

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1.

10.5 Enterprise

  • Present starting in MariaDB Enterprise Server 10.5.3-1.

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1.

EXTERNAL REFERENCES