存储过程,default

drop table if exists t;create table t (s1 int);    insert into t values (5);  select * from t;-- --------------------------------------------------drop procedure if exists p10;delimiter //create procedure p10 ()  begin    declare a, b int default 8;    insert into t values (a);    select s1 * a from t where s1 >= b; end; //  delimiter ;call p10();/*+--------+| s1 * a |+--------+|     64 |+--------+*/