Mysql Stored Procedure

Mysql Stored Procedure

Note: The difference between stored procedures and functions: stored procedures do not return values. 1. view the Stored procedure show procedure status \ G2, delete the Stored procedure drop procedure stored procedure name 3. create 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. Call the 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 $