MySQL Forums
Forum List  »  Stored Procedures

Advanced Search
New Topic

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.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
How to Remove All Stored Procedures in a Specific Database
4497
Ken Grigsby
November 08, 2018 02:00PM
Re: How to Remove All Stored Procedures in a Specific Database
1021
Peter Brawley
November 08, 2018 07:57PM
Re: How to Remove All Stored Procedures in a Specific Database
898
Ken Grigsby
November 08, 2018 09:03PM
Re: How to Remove All Stored Procedures in a Specific Database
921
Peter Brawley
November 09, 2018 11:23AM
Re: How to Remove All Stored Procedures in a Specific Database
774
Ken Grigsby
November 09, 2018 01:07PM


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.