黄骅贴吧桃花路_企业信息系统查询系统官网江苏_电脑系统优化软件哪个好用_友情链接购买平台

SHOW CREATE FUNCTION 语句

SHOW CREATE FUNCTION func_name

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

mysql> show create function world.sum \G
*************************** 1. row ***************************Function: sumsql_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_SUBSTITUTIONCreate Function: CREATE DEFINER=`root`@`%` FUNCTION `sum`(a INT, b INT) RETURNS int(11)
BEGINRETURN a + b;
END
character_set_client: utf8mb4
collation_connection: utf8mb4_general_ciDatabase Collation: utf8_bin
1 row in set (0.00 sec)mysql>