Code to show procedures in Mysql

Question

Asked 8 years, 1 month ago

Viewed 2,898 times

5

What Mysql code to display procedures created by me?

1

you want to know how to show the code of your trial? you want a list of all your procedures? be more specific

– guijob

2016/10/09 at 22:36
Did the answer solve your question? Do you think you can accept it? See [tour] if you don’t know how you do it. This would help a lot to indicate that the solution was useful to you. You can also vote on any question or answer you find useful on the entire site.

– Maniero

2016/10/15 at 15:31

1 answer

Browser other questions tagged mysql sql

You are not signed in. Login or sign up in order to post.

by Maniero • **444,682** points · Answer 1 · 2016-10-09T22:36:09+00:00

I believe that’s what you want:

SELECT ROUTINE_TYPE, ROUTINE_NAME
    FROM INFORMATION_SCHEMA.ROUTINES
    WHERE ROUTINE_SCHEMA = 'nome do banco de dados aqui';

You may also want to list:

SHOW PROCEDURE STATUS;

And show the code:

SHOW PROCEDURE CODE;