Home >Database >Mysql Tutorial >MySql执行存储过程时错误的处理方式_MySQL

MySql执行存储过程时错误的处理方式_MySQL

WBOY
WBOYOriginal
2016-06-01 13:36:311391browse

bitsCN.com

MySql执行存储过程时错误的处理方式

 

创建一个简单的存储过程: 

DELIMITER $$ 

CREATE PROCEDURE proc_book() 

BEGIN 

SELECT * FROM book; 

END $$ 

DELIMITER ; 

调用这个存储过程: 

CALL proc_book(); 

 

有可能会出现以下错误代码: 

ERROR 1436 (HY000): Thread stack overrun 

修改方式如下: 

修改 

My.ini中的配置 

thread_stack = 256K原来是128K,将内存修改成256K即可。 
 

bitsCN.com
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn