CODE EXAMPLE FOR SQL

stored procedure replace

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.