mysql的存储过程

1、从MYSQL已有存储过程导出来的DDL，是不包含DELIMITER的，所以一直在报错

2、涉及到两个游标的嵌套，并且是关联的

 

DELIMITER //
CREATE DEFINER=`root`@`%` PROCEDURE `bugtrace`.`process_time_stat`()
BEGIN
 DECLARE v_finished INTEGER DEFAULT 0;
 DECLARE v_answern INTEGER DEFAULT 0;

 DECLARE v_questionid varchar(100) DEFAULT "";
 DECLARE v_userid varchar(100) DEFAULT "";
 DECLARE v_username varchar(100) DEFAULT "";
 DECLARE v_time float DEFAULT 0;
 DECLARE v_starttime,v_closetime datetime;

 
 DEClARE question_cursor CURSOR FOR 
 SELECT tq.id, timestampdiff(HOUR, createtime, closelooptime),tqe.value,tq.createtime,tq.closelooptime,tu.text
 FROM t_questioninfo tq ,t_questioninfo_extend tqe ,t_user tu 
 where tq.status in (3,5) and tq.deleteflag  = 2 and tq.productid in (1,2,3) and tq.createtime >= '2020-1-1' 
 and tqe.