13.7.5.20 SHOW FUNCTION STATUS 语句
SHOW FUNCTION STATUS
[LIKE 'pattern' | WHERE expr]此语句类似于SHOW PROCEDURE STATUS，但用于存储函数。参见第 13.7.5.28 节 “SHOW PROCEDURE STATUS 语句”。
mysql> show function status like 'sum';
+-------+------+----------+---------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+
| Db | Name | Type | Definer | Modified | Created | Security_type | Comment | character_set_client | collation_connection | Database Collation |
+-------+------+----------+---------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+
| world | sum | FUNCTION | root@% | 2024-08-18 16:37:06 | 2024-08-18 16:37:06 | DEFINER | | utf8mb4 | utf8mb4_general_ci | utf8_bin |
+-------+------+----------+---------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+
1 row in set, 1 warning (0.00 sec)
mysql>
mysql> show function status like 'sum' \G
*************************** 1. row ***************************
Db: world
Name: sum
Type: FUNCTION
Definer: root@%
Modified: 2024-08-18 16:37:06
Created: 2024-08-18 16:37:06
Security_type: DEFINER
Comment:
character_set_client: utf8mb4
collation_connection: utf8mb4_general_ci
Database Collation: utf8_bin
1 row in set, 1 warning (0.00 sec)
mysql>
