註:存儲過程和函數的區別:存儲過程沒有返回值。 1、查看存儲過程 show procedure status \G 2、刪除存儲過程drop procedure 存儲過程名 3、創建存儲過程 create procedure 存儲過程名(n int) begin if j='h' then select * from g where num>n; else select * from g where num<n; end$ 4、調用存儲過程: call 存儲過程名(); 例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$