创建存储过程
Create (definer=user/current_user) procedure *** ((in/out/inout) *** type,…) (comment’…’/language sql/(not) deterministic/(contains sql/no sql/reads sql data /modifyies sql data)/sql security (definer/invoker) begin … end;
Delimiter $$
Create procedure sp_update_sex(int cid int,int csex char(1))
Begin
Update customers set cust_sex=csex where cust_id=cid;
End $$
Show procedure status;
Show create procedure ***;