问题描述
我已经通过远程访问在MySQL中创建了许多存储过程.这些程序效果很好.
I have created numbers of stored procedures in MySQL through remote access. And those procedures worked well.
几天后，我通过远程访问连接到数据库.所有存储过程都还活着，但是在尝试调用这些过程时，我意识到过程内的SQL查询已经消失了.有人知道原因吗?
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?
推荐答案
如果SHOW CREATE PROCEDURE(请参见文档)并未向您显示该过程(带有SQL查询)，您可能存在一些权限问题-您需要成为该过程的所有者或拥有SELECT访问mysql.proc表.
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.
这篇关于我在MySQL存储过程中看不到SQL查询！的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！