MySQL stored procedures

Note: The difference between stored procedures and functions: stored procedures do not return a value. 1. View stored procedure Show procedure status \g2, delete stored procedure drop procedure stored Procedure name 3, create stored procedure creation procedure stored procedure name (n int) beginif j= ' h '  then  SELECT * from g where Num>n;else  select * from G where num<n;end$4, invoke stored procedure: Call stored procedure name (), example 1:create procedure p1 (n smallint) begin  declare i int;  declare s int;  Set I=1;  Set s=0;  While i<=n do    set s=s+i;    Set i=i+1;  End While;  Select s;end$

MySQL stored procedures