MYSQL-查看函数创建语句语法（五）

SHOW CREATE FUNCTION 语句

SHOW CREATE FUNCTION func_name

此语句类似于 `SHOW CREATE PROCEDURE 的方法，但用于存储过程。

mysql> show create function world.sum \G
*************************** 1. row ***************************
            Function: sum
            sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
     Create Function: CREATE DEFINER=`root`@`%` FUNCTION `sum`(a INT, b INT) RETURNS int(11)
BEGIN
  RETURN a + b;
END
character_set_client: utf8mb4
collation_connection: utf8mb4_general_ci
  Database Collation: utf8_bin
1 row in set (0.00 sec)

mysql>