Outdated Version

You are viewing an older version of this section. View current production version.

SHOW AGGREGATES

Lists any existing user-defined aggregate functions (UDAF) in the specified database.

Syntax

SHOW AGGREGATES [EXTENDED] [{FROM | IN} database_name] [LIKE pattern]

Remarks

You can use SHOW AGGREGATES EXTENDED to see detailed information about each UDAF in the specified database, including each of the UDFs that are executed for each step in the UDAF function body.

Examples

SHOW AGGREGATES in a Database

The following example lists each UDAF function in the target database.

SHOW AGGREGATES in db1;
+-------------------+
| Aggregates_in_db1 |
+-------------------+
| myaggregate       |
+-------------------+
1 row in set (0.00 sec)

SHOW AGGREGATES EXTENDED

The following example shows detailed information about each UDAF in the current database.

SHOW AGGREGATES EXTENDED \G;
*************************** 1. row ***************************
Aggregates_in_db1: multiply_hundred
          Definer: root@localhost
 Argument type(s): bigint(20) NULL
       State type: bigint(20) NULL
      Return type: bigint(20) NULL
  Initialize with: multiply_hundred_init
     Iterate with: multiply_hundred_iter
       Merge with: multiply_hundred_merge
   Terminate with: multiply_hundred_terminate
1 row in set (0.00 sec)

SHOW AGGREGATES LIKE

The following example demonstrates how to find a specific UDAF in the target database.

SHOW AGGREGATES LIKE 'multiply%';
+-------------------------------+
| Aggregates_in_db1 (multiply%) |
+-------------------------------+
| multiply_hundred              |
+-------------------------------+
1 row in set (0.00 sec)

Related Topics