MYSQL-查看数据库中的存储过程语法（六）

13.7.5.9 SHOW CREATE PROCEDURE 语句

SHOW CREATE PROCEDURE proc_name

此语句是 MySQL 扩展。它返回确切的字符串 ，可用于重新创建命名的存储过程。SHOW CREATE FUNCTION，显示有关存储函数的信息 （参见第 13.7.5.8 节“ SHOW CREATE FUNCTION 语句”）。

您必须是 routine 子句或具有对表的 SELECT 访问权限。

mysql> SHOW CREATE PROCEDURE test.citycount\G
*************************** 1. row ***************************Procedure: citycountsql_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 Procedure: CREATE DEFINER=`me`@`localhost`PROCEDURE `citycount`(IN country CHAR(3), OUT cities INT)BEGINSELECT COUNT(*) INTO cities FROM world.cityWHERE CountryCode = country;END
character_set_client: utf8
collation_connection: utf8_general_ciDatabase Collation: latin1_swedish_cimysql> SHOW CREATE FUNCTION test.hello\G
*************************** 1. row ***************************Function: hellosql_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=`me`@`localhost`FUNCTION `hello`(s CHAR(20))RETURNS char(50) CHARSET latin1DETERMINISTICRETURN CONCAT('Hello, ',s,'!')
character_set_client: utf8
collation_connection: utf8_general_ciDatabase Collation: latin1_swedish_ci

character_set_client 是系统变量。 是 collation_connection系统 变量。 是数据库的排序规则