SHOW CREATE AGGREGATE
Shows the function definition and other attributes for a user-defined aggregate function (UDAF).
Syntax
SHOW CREATE AGGREGATE function_name
Remarks
See the Permission Matrix for the required permission.
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