MySQL basic four stored procedures

The stored procedure: the Declaration and assignment of a variable.

CREATE PROCEDURE P1 ()

Begin

declare age int default 18;    set age :=age+20;select age from dual;

End

Calling the stored procedure: Call P1 (); The result is as follows:

Second, the stored procedure: simple control statement.

CREATE PROCEDURE P2 ()
Begin

declare age int default 18;if age>=18 then select ‘已成年‘ ;else  select ‘未成年‘;end if;

End
Calling the stored procedure: Call P2 (); The result is as follows:

MySQL basic four stored procedures