mysql编写存储过程

CREATE  PROCEDURE `copy_record_out`()
BEGIN
DECLARE startYear int;
DECLARE endYear int;
DECLARE startMonth int;
DECLARE endMonth int;
DECLARE startTime dateTime;
DECLARE endTime dateTime;
DECLARE middleTime dateTime;
declare startTimeStr VARCHAR(32);
declare middleTimeStr VARCHAR(32);
select 1 into startMonth;
select str_to_date('2019-12-01 00:00:00','%Y-%m-%d %H:%i:%s') into startTime;
select str_to_date('2020-01-01 00:00:00','%Y-%m-%d %H:%i:%s') into endTime;
while startTime<endTime do
select YEAR(startTime) into startYear;
select MONTH(startTime) into startMonth;
select DATE_FORMAT(startTime,'%Y-%m-%d %H:%i:%s') into startTimeStr;
select date_add(startTime, interval 1 HOUR) into middleTime;
select DATE_FORMAT(middleTime,'%Y-%m-%d %H:%i:%s') into middleTimeStr;
set @table_name = concat("t_park_record_out_archive_",startYear,"_",startMonth);
set @statement = concat("insert into ",@table_name, "(
create_time,update_time )
select  create_time, update_time from t_park_record_out 
where out_time>='",startTimeStr,"' and out_time<'",middleTimeStr,"';");
prepare stmt from @statement;
execute stmt;
commit;
delete from t_park_record_out where out_time>=startTime and out_time<date_add(startTime, interval 1 HOUR);
commit;
select middleTime into startTime;
select YEAR(startTime) into startYear;
select MONTH(startTime) into startMonth;
end while;
end;