Outdated Version

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

SHOW CREATE AGGREGATE

Shows the function definition and other attributes for a user-defined aggregate function (UDAF).

Syntax

SHOW CREATE AGGREGATE function_name

Example

The following example demonstrates how to execute a SHOW CREATE AGGREGATE statement for a UDAF.

SHOW CREATE AGGREGATE multiply_hundred \G;
*************************** 1. row ***************************
           Aggregate: multiply_hundred
    Create Aggregate: CREATE AGGREGATE `multiply_hundred` (bigint(20) NULL) RETURNS bigint(20) NULL WITH STATE bigint(20) NULL INITIALIZE WITH multiply_hundred_init ITERATE WITH multiply_hundred_iter MERGE WITH multiply_hundred_merge TERMINATE WITH multiply_hundred_terminate;
character_set_client: utf8
collation_connection: utf8_general_ci
1 row in set (0.00 sec)

Related Topics