MySQL Forums
Forum List  »  Stored Procedures

How to Remove All Stored Procedures in a Specific Database
Posted by: Ken Grigsby
Date: November 08, 2018 02:00PM

In MySQL 8 the database table `mysql`.`proc` does not exist. Previously I used this table to delete/remove/clear all stored procedures and recreate them from the source versioned code. This works very well to make sure development stored procedures where saved to source versioning before going to production.

Previously this SQL query worked.
DELETE FROM `mysql`.`proc` WHERE `type` = 'PROCEDURE' AND `db` = 'test';

1) Was the functionality to remove all stored procedures from a specific database in one statement removed from MySQL 8?
2) Is there an alternate way to achieve the results of the query in one statement?

Options: ReplyQuote


Subject
Views
Written By
Posted
How to Remove All Stored Procedures in a Specific Database
99
November 08, 2018 02:00PM


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.