DROP PROCEDURE IF EXISTS db.sp_stock_list; //or Could also mention that MariaDB, a "drop-in replacement" for MySQL, does support the CREATE OR REPLACE PROCEDURE syntax since version 10.1 Only.