MySQL Forums
Forum List  »  Stored Procedures

Re: system stored procedures
Posted by: Peter Brawley
Date: July 11, 2019 10:58AM

Since 5.7, the sys database has quite a few sprocs & funcs, list them with ...

select routine_name, routine_type
from information_schema.routines
where routine_schema='sys';

... and eg show the source of the diagnostics sproc with ...

show create procedure sys.diagnostics\G

(watch out, it's huge)

Options: ReplyQuote


Subject
Views
Written By
Posted
739
July 11, 2019 07:39AM
Re: system stored procedures
321
July 11, 2019 10:58AM
314
July 12, 2019 06:13AM


Sorry, you can't reply to this topic. It has been closed.

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.