DEV Community

Cover image for How to create Stored Procedure in MySQL
The Dream Coding
The Dream Coding

Posted on

1

How to create Stored Procedure in MySQL

#mysql #sql #bigdata #database

=> syntaxe 

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

delimiter ;
Enter fullscreen mode Exit fullscreen mode

=> To execute the stored procedure 

Call name_proc(parametrs ..);
Enter fullscreen mode Exit fullscreen mode

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

Top comments (0)

👋 Kindness is contagious

Dive into this insightful write-up, celebrated within the collaborative DEV Community. Developers at any stage are invited to contribute and elevate our shared skills.

A simple "thank you" can boost someone’s spirits—leave your kudos in the comments!

On DEV, exchanging ideas fuels progress and deepens our connections. If this post helped you, a brief note of thanks goes a long way.

Okay