How to create Stored Procedure in MySQL

=> syntaxe

drop procedure if exists name_proc;
delimiter $$
create procedure name_proc(parametrs ..)
begin
    -- statement
end 
$$

delimiter ;

=> To execute the stored procedure

Call name_proc(parametrs ..);

i explaine how to create Stored Procedure in MySQL on youtube

click this => vidéo

this is my channel on youtube

click this => The Dream Coding