查看存储过程:
show procedure status \G;
创建存储过程:
delimiter //
create procedure p_girl(in a int)
begin
set a=a+12;
select a;
end //
delimiter ;
调用存储过程:
call p_girl(13);
删除存储过程:
drop procedure p_girl;
查看存储过程:
show procedure status \G;
创建存储过程:
delimiter //
create procedure p_girl(in a int)
begin
set a=a+12;
select a;
end //
delimiter ;
调用存储过程:
call p_girl(13);
删除存储过程:
drop procedure p_girl;