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

这篇文章主要为大家详细介绍了MySQL存储过程相互调用并获得错误码示例，具有一定的参考价值，可以用来参考一下。

对此感兴趣的朋友，看看idc笔记做的技术笔记！

代码如下:

 
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> 

注：关于MySQL存储过程相互调用并获得错误码示例的内容就先介绍到这里，更多相关文章的可以留意