Home >Backend Development >PHP Tutorial > MYSQL 存储过程调用存储过程解决方案

MYSQL 存储过程调用存储过程解决方案

WBOY
WBOYOriginal
2016-06-13 13:51:11982browse

MYSQL 存储过程调用存储过程
P1
CREATE PROCEDURE P1(IN hid int(8))
bengin
..
end

P2
CREATE PROCEDURE P2(IN hid int(8))
bengin
exec P1(hid);
..
end

为什么提示exec P1(hid); 有错呢

------解决方案--------------------
hid传递的参数看是否为int型

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