MySQL Forums
Forum List  »  Newbie

Query to find invalid routines on a 5.7.2 database
Posted by: cesar hijar
Date: March 23, 2023 10:17AM

Hi all

Where can I find the STATUS of my procedures and functions belong to my database?
I need to know this through a query.
I found this query but this doesn't have a column describing INVALID or something like that.



SELECT *
FROM information_schema.routines
WHERE routine_schema = 'MYDB'
ORDER BY routine_name;

Please would you send me a query in order to know which routine is INVALID?

thanks in advanced.
regards

Options: ReplyQuote


Subject
Written By
Posted
Query to find invalid routines on a 5.7.2 database
March 23, 2023 10:17AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.