create or replace procedure mechmsginfoProc is
saveDays number := 1;
curDate char(8);
begin
end
create procedure mechmsginfoProc()
begin
DECLARE saveDays int;
DECLARE curDate char(8);
set saveDays=1;
end;
参考自:MySQL存储过程详解 http://www.data.5helpyou.com/article314.html
楼上的答案太标准了,连这个
set saveDays=1;
都有,非常等价