我在MySQL存储过程中看不到SQL查询！ [英] I cant see SQL Queries in MySQL Stored Procedure!

问题描述

我已经通过远程访问在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(请参见

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查询！的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！