5
What Mysql code to display procedures created by me?
1 answer
4
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';
I put in the Github for future reference.
You may also want to list:
SHOW PROCEDURE STATUS;
And show the code:
SHOW PROCEDURE CODE;
-
I think he wants the
sp_helptext <nome_da_proc>but I’m not sure... -
2
I don’t know about this in Mysql.
-
Voce is right. i think he wants a similar command in Mysql
Browser other questions tagged mysql sql
You are not signed in. Login or sign up in order to post.
you want to know how to show the code of your trial? you want a list of all your procedures? be more specific
– guijob
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