DEV Community: The Dream Coding

How to create Stored Procedure in MySQL

The Dream Coding — Sun, 13 Nov 2022 00:53:31 +0000

=> 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

How to use delimiter in MySQL

The Dream Coding — Sat, 12 Nov 2022 10:11:53 +0000

when writing SQL statements , we use
the delimiter to separate betwene
two Statements

delimiter ;
select * from school ;
delimiter $$
select * from student $$

=>the default delimiter
is semicolon (;)

select * from school ;

=> Setting a different the delimiter
allows us to execute all statements
as a single statements

for example

delimiter $$
create function (para int) returns int
begin
-- statement 
end
$$
delimiter ;

=> in this statement we want to execute
function or stored procedures in one
statemente . so , we use dilimiter

i explaine how to use delimiter in MySQL on youtube

click this => vidéo

this is my channel on youtube

click this => The Dream Coding

How to create function in MySQL

The Dream Coding — Sat, 12 Nov 2022 09:49:44 +0000

1. Syntax

drop function if exists function_name ;
delimiter $$
CREATE FUNCTION function_name [ (parameter datatype [, parameter datatype]) ]
RETURNS return_datatype
BEGIN
    -- statements
END
$$
-- for use the function 
select function_name(parameter);

2. example

drop function if exists countscoll;
delimiter $$
CREATE FUNCTION countscoll( cit int ) 
returns int 
begin 
   declare tota int ;
   set tota = ( select count(*) from school 
   where city = cit );
   return tota ;
end
$$
delimiter ;
select countscoll("new york");

3. remark

we use function when we return value or Variable

4. i explaine how to create function in MySQL on youtube

click this => vidéo

5. this is my channel on youtube

click this => The Dream Coding