Geek asks and answers

I can not see SQL queries in MySQL stored procedure!

I created the number of stored procedures in MySQL through remote access. And these procedures worked well.

A few days later, when I connected to the database through remote access. All stored procedures were alive, but when I tried to call these procedures, I realized that the SQL queries inside the procedures disappeared. Does anyone know the reason?

0
source share
1 answer

If SHOW CREATE PROCEDURE(see docs ) does not show you the procedure (with SQL queries inside), you probably have some permission problems - you must be the owner of the procedure or have SELECTaccess to the table mysql.proc.

+1
source

More articles:


All Articles