I have created numbers of stored procedures in MySQL through remote access. And those procedures worked well.
我通过远程访问在MySQL中创建了许多存储过程。这些程序运作良好。
After a few days when I connected to Database through remote access. All stored procedures were alive but while was trying to call those procedures, I realized that SQL queries inside procedures had gone. Anyone knows the reason?
几天后,我通过远程访问连接到数据库。所有存储过程都是活着的,但在尝试调用这些过程时,我意识到程序内部的SQL查询已经消失了。谁知道原因?
1 个解决方案
#1
If SHOW CREATE PROCEDURE
(see docs) isn't showing you the procedures (with SQL queries inside) you probably have some permission problems -- you need to be the owner of the procedure or have SELECT
access to the mysql.proc
table.
如果SHOW CREATE PROCEDURE(请参阅docs)没有向您显示过程(内部有SQL查询),您可能会遇到一些权限问题 - 您需要成为过程的所有者或者具有对mysql.proc表的SELECT访问权限。
#1
If SHOW CREATE PROCEDURE
(see docs) isn't showing you the procedures (with SQL queries inside) you probably have some permission problems -- you need to be the owner of the procedure or have SELECT
access to the mysql.proc
table.
如果SHOW CREATE PROCEDURE(请参阅docs)没有向您显示过程(内部有SQL查询),您可能会遇到一些权限问题 - 您需要成为过程的所有者或者具有对mysql.proc表的SELECT访问权限。