赞
踩
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.
Copyright © 2003-2013 www.wpsshop.cn 版权所有,并保留所有权利。