调用无参存储过程
call procedureName();

调用含有in类型有参存储过程
set @variableName=variableValue;
call procedureName(@variableName);

调用含有out类型的参数存储过程
set @variableName=defaultValue;
call procedureName(@variableName);

删除
drop procedure procedureName;

循环体loop
in out参数

delimiter //
create procedure p_person()
begin
select * from t_persons;
end
//

#调用
call p_person();

#删除
drop procedure p_person;

#带有in参数
delimiter //
create procedure p_person(in myid int)
begin
select * from t_persons where id=myid;
end
//

set @myid=1;
call p_person(@myid);


delimiter //
create procedure p_person(out myName varchar(20), in myid bigint)
begin
select name into myName from t_persons where id = myid;
end
//

set @myName='';
call p_person(@myName,2);
select @myName;