MySQL存储过程相互调用并获得错误码示例

109 阅读 0 评论 72 点赞

我是靠谱客的博主愉快豌豆，最近开发中收集的这篇文章主要介绍MySQL存储过程相互调用并获得错误码示例，觉得挺不错的，现在分享给大家，希望可以做个参考。

概述

复制代码代码如下:

 
mysql> 
mysql> delimiter $$ 
mysql> 
mysql> CREATE PROCEDURE myProc() 
-> MODIFIES SQL DATA 
-> BEGIN 
-> DECLARE l_status VARCHAR(20); 
-> 
-> CALL myProc1(l_status); 
-> IF l_status='Duplicate Entry' THEN 
-> SELECT CONCAT('Warning: using existing definition for location ') AS warning; 
-> END IF; 
-> END$$ 
Query OK, 0 rows affected (0.00 sec) 

mysql> 
mysql> CREATE PROCEDURE myProc1(OUT out_status VARCHAR(30)) 
-> BEGIN 
-> set out_status = 'Duplicate Entry'; 
-> END$$ 
Query OK, 0 rows affected (0.00 sec) 

mysql> 
mysql> 
mysql> delimiter ; 
mysql> call myProc(); 
+--------------------------------------------------+ 
| warning | 
+--------------------------------------------------+ 
| Warning: using existing definition for location | 
+--------------------------------------------------+ 
1 row in set (0.00 sec) 

Query OK, 0 rows affected (0.01 sec) 

mysql> drop procedure myProc; 
Query OK, 0 rows affected (0.00 sec) 

mysql> drop procedure myProc1; 
Query OK, 0 rows affected (0.00 sec) 

mysql> 
mysql> 