我无法在MySQL存储过程中看到SQL查询!

时间:2022-04-09 21:01:05

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访问权限。