drop table if exists t;
create table t (s1 int);
insert into t values (5);
select * from t;
-- --------------------------------------------------
drop procedure if exists p8;
delimiter //
create procedure p8 ()
begin
declare a int;
declare b int;
set a = 6;
set b = 3;
insert into t values (a);
select s1 * a from t where s1 >= b;
end; //
delimiter ;
call p8();
存储过程,declare
最新推荐文章于 2022-11-28 16:53:50 发布