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
