数据库 - Mysql的存储过程真的是个坑！求助下面的存储过程哪里错啦，实在是找不到哪里的问题了。

问题描述

BEGIN

declare step1,step2 varchar(50);declare p_tar_code varchar(10);DECLARE p_tYear,p_period int;DECLARE p_centAll,p_up_comCent decimal(5,2);-- 1：获取当前年度和季度select period,tyear into p_period,p_tYear from tm_checkmain where id = 95 LIMIT 1;-- 2：如果季度是1，则上年得分为0，否则要计算 if period = 21 then set p_up_comCent = 0; end if

select tar_code into p_tar_code from tm_checkdetails where id = 95 LIMIT 1;

set str = p_tar_code;

END

将IF判断注释掉，则通过，否则则报错。

One or more errors have occurred while processing your request:下列查询失败了: 'CREATE DEFINER=root@localhost PROCEDURE comCent(IN cm_id INT(11) UNSIGNED, OUT str VARCHAR(10)) NO SQL SQL SECURITY DEFINER BEGIN declare step1,step2 varchar(50); declare p_tar_code varchar(10); DECLARE p_tYear,p_period int; DECLARE p_centAll,p_up_comCent decimal(5,2); -- 1：获取当前年度和季度 select period,tyear into p_period,p_tYear from tm_checkmain where id = 95 LIMIT 1; -- 2：如果季度是1，则上年得分为0，否则要计算 if period = 21 then set p_up_comCent = 0; end if -- select tar_code into p_tar_code from tm_checkdetails where id = 95 LIMIT 1; -- set step2 = ’如果是月则返回’; -- set str = p_tar_code; END'MySQL 返回： #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 ’END’ at line 22

请教高手，IF判断根本没有错误呀。

问题解答