MySQL存储过程实例

MySQL存储过程实例代码如下：

drop table if exists t1;create table t1(id int not null);insert into t1 values(1), (2), (3);delimiter //create procedure myfun(in para int)beginselect * from t1 where id = para;end;//delimiter ;set @a = 1;call myfun(@a);call myfun(2);