为啥跑不通 求助
DELIMITER $$
BEGIN
DECLARE lv_selectsql text;
DECLARE lv_countflag DECIMAL;
SELECT COUNT(1) INTO lv_countflag
FROM r_check_config_cq;
SET @check_flag = 0;
WHILE @check_flag < lv_countflag DO
DECLARE cv_selectsql CURSOR FOR
SELECT a.selectsql
FROM r_check_config_cq a;
OPEN cv_selectsql;
FETCH cv_selectsql INTO lv_selectsql;
CLOSE cv_selectsql;
SET @selectsql = CONCAT('INSERT INTO r_check_report_cq ',lv_selectsql);
SELECT @selectsql;
PREPARE s FROM @selectsql;
EXECUTE s;
DEALLOCATE PREPARE s;
SET @check_flag = @check_flag + 1;
END WHILE;
END
$$
DILIMITER ;
DELIMITER $$
BEGIN
DECLARE lv_selectsql text;
DECLARE lv_countflag DECIMAL;
SELECT COUNT(1) INTO lv_countflag
FROM r_check_config_cq;
SET @check_flag = 0;
WHILE @check_flag < lv_countflag DO
DECLARE cv_selectsql CURSOR FOR
SELECT a.selectsql
FROM r_check_config_cq a;
OPEN cv_selectsql;
FETCH cv_selectsql INTO lv_selectsql;
CLOSE cv_selectsql;
SET @selectsql = CONCAT('INSERT INTO r_check_report_cq ',lv_selectsql);
SELECT @selectsql;
PREPARE s FROM @selectsql;
EXECUTE s;
DEALLOCATE PREPARE s;
SET @check_flag = @check_flag + 1;
END WHILE;
END
$$
DILIMITER ;
本版等级:T1
结帖率:0%
DECLARE lv_selectsql text;
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DECLARE lv_selectsql text' at line 2 是这样的