create or replace procedure mechmsginfoProc is
saveDays number := 1;
curDate char(8);
begin
end
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