查看MySQL中的存储过程/函数定义？
要在MySQL中查看存储过程/函数定义，可以使用show命令。语法如下-
SHOW CREATE PROCEDURE yourProcedureName;
要了解上述语法，您可以创建一个过程并检查该定义。让我们创建一个存储过程-
mysql> delimiter // mysql> create procedure AllRecords() -> begin -> select *from student; -> end //
您可以在call命令的帮助下调用存储过程。查询如下-
mysql> delimiter ; mysql> call AllRecords();
以下是输出-
+------+-------+ | id | Name | +------+-------+ | 1 | John | | 2 | Bob | | 3 | Smith | | 6 | John | +------+-------+ 4 rows in set (0.14 sec)
现在，您可以在开始讨论的上述语法的帮助下检查定义。查询如下-
mysql> show create procedure AllRecords;
这是输出-
+------------+--------------------------------------------+-----------------------------------------------------------------------+----------------------+----------------------+--------------------+ | Procedure | sql_mode | Create Procedure | character_set_client | collation_connection | Database Collation | +------------+--------------------------------------------+-----------------------------------------------------------------------+----------------------+----------------------+--------------------+ | AllRecords | STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION | CREATE DEFINER=`root`@`%` PROCEDURE `AllRecords`() begin select *from student;end | utf8 | utf8_general_ci | utf8mb4_unicode_ci | +------------+--------------------------------------------+-----------------------------------------------------------------------+----------------------+----------------------+--------------------+ 1 row in set (0.00 sec)
要检查MySQL中的函数定义，可以使用函数代替过程。语法如下：-
SHOW CREATE FUNCTION yourFunctionName;