MySQL Forums
Forum List  »  Stored Procedures

Re: How to Remove All Stored Procedures in a Specific Database
Posted by: Peter Brawley
Date: November 09, 2018 11:23AM

> So your answer to my question about the functionality
> being removed is that it was a back door?

Stored routine storage has been re-engineered and a back door has been removed.

> Additionally you are saying there is no easy way
> to remove all stored procedures from a database.

It's about as easy, but sounder, to code dropping one or more routines named dynamically in a language with a MySQL API (eg PHP, Python) as it was to use mysql.procs as a back door, so no, I'm not saying there's no easy way.

If you really want SQL syntax for dropping multiple routine, consider making a feature request on the bugs page.



Edited 1 time(s). Last edit at 11/09/2018 11:24AM by Peter Brawley.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: How to Remove All Stored Procedures in a Specific Database
935
November 09, 2018 11:23AM


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.