【MySQL】调用储存过程显示 ERROR 1305 (42000): PROCEDURE test.sp1 does not exist |
您所在的位置:网站首页 › 机顶盒错误代码1305怎么解决 › 【MySQL】调用储存过程显示 ERROR 1305 (42000): PROCEDURE test.sp1 does not exist |
问题描述:
1.在MySQL中创建了一个简单的查询存储过程: mysql> CREATE PROCEDURE spl() SELECT VERSION(); Query OK, 0 rows affected (0.01 sec)2.然后用CALL调用此存储过程,报错 ERROR 1305 (42000): PROCEDURE test.sp1 does not exist: mysql> CALL sp1; ERROR 1305 (42000): PROCEDURE test.sp1 does not exist 问题排查:1.首先考虑是否是此储存过程当真不在,查看当前存储过程,发现存储过程存在: mysql> SHOW PROCEDURE STATUS; +------+------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | Db | Name | Type | Definer | Modified | Created | Security_type | Comment | character_set_client | collation_connection | Database Collation | +------+--- |
今日新闻 |
点击排行 |
|
推荐新闻 |
图片新闻 |
|
专题文章 |
CopyRight 2018-2019 实验室设备网 版权所有 win10的实时保护怎么永久关闭 |