存储过程begin/end

drop table if exists t;create table t (s1 int);    insert into t values (5);  select * from t;-- --------------------------------------------------drop procedure if exists p7;delimiter //create procedure p7()  begin    set @a = 6;    set @b = 5;  -- 定义两个客户端变量  insert into t values (@a);    select s1 * @a from t where s1 >= @b;  end; // delimiter ;call p7();/*+---------+| s1 * @a |+---------+|      30 ||      36 |+---------+*/