In this tutorial, I’ll show you how to do just that ... All that’s left is to exit MySQL with the command exit. Your database is ready to use. Check out this article I found on TechRepublic.

Drop and recreate the procedure (MySQL doesn’t allow direct modification). 4. Drop a stored procedure -To completely removes the stored procedure from the database. Syntax :DROP PROCEDURE ...