Comments - Stored Procedure Overview

7 years, 1 month ago Karl Levik

"However, you cannot change the parameters or body of a stored procedure using this statement; to make such changes, you must drop and re-create the procedure using DROP PROCEDURE and CREATE PROCEDURE."

From MariaDB 10.1.4 onwards you can do CREATE OR REPLACE PROCEDURE which is atomic and therefore better than two statements DROP PROCEDURE + CREATE PROCEDURE".

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.