我无法找出以下查询的语法错误。。帮助帮助帮助
CREATE PROCEDURE VoucherNumberGenerationForClass(
p_voucherType varchar(50),
p_yearId varchar(50),
p_NO longtext)
begin
IF((SELECT COUNT(suffixPrefixId)FROM tbl_SuffixPrefix WHERE (yearId = p_yearId) AND (voucherType = p_voucherType))<>0)
then
DECLARE p_prefix VARCHAR(50);
DECLARE p_startIndex int ;
DECLARE p_suffix VARCHAR(50) ;
DECLARE p_voucherNo VARCHAR(50) ;
DECLARE p_prefix1 VARCHAR(50) ;
DECLARE p_suffix1 VARCHAR(50) ;
IF ((( SELECT COUNT(suffixPrefixId)FROM tbl_SuffixPrefix WHERE (yearId = p_yearId) AND (voucherType = p_voucherType) ))<>0 );
then
SET p_prefix=(SELECT ifnull(prefix,'') FROM tbl_SuffixPrefix WHERE (yearId = p_yearId) AND (voucherType = p_voucherType) );
SET p_suffix=(SELECT ifnull(suffix,'') FROM tbl_SuffixPrefix WHERE (yearId = p_yearId) AND (voucherType = p_voucherType) );
SET p_startIndex=(SELECT startIndex FROM tbl_SuffixPrefix WHERE (yearId = p_yearId) AND (voucherType = p_voucherType) );
SET p_startIndex=p_startIndex-1;
IF p_voucherType='Sales Invoice'
then SET p_voucherNo=( SELECT ifnull(MAX(voucherNo+1),1) FROM tbl_SalesMaster WHERE((suffixPrefixId = (SELECT suffixPrefixId FROM tbl_SuffixPrefix WHERE (yearId = p_yearId) AND (voucherType = p_voucherType) ))
) )
END if ;
SET p_voucherNo=p_voucherNo+p_startIndex ;
SET p_voucherNo= p_prefix+ p_voucherNo+p_suffix ;
SELECT p_voucherNo ;
END if;
ELSEIF
IF p_voucherType='Sales Invoice'
then SET p_voucherNo=( SELECT ifnull(MAX(voucherNo+1), 1) FROM tbl_SalesMaster ) ;
SELECT p_voucherNo ;
END IF ;
end ;
错误1064(42000):您的SQL语法有错误;查看手册对应于您的MySQL服务器版本,以便在DECLA附近使用正确的语法RE p_prefix VARCHAR(50);DECLARE p_startIndex int;第8行的声明p_suffix VARCHA'
尝试将DECLARE
语句放在BEGIN
:之后
DECLARE
只允许在BEGIN ... END
复合语句内部,并且必须在其开头,在任何其他语句之前。
将COUNT(后缀PrefixId)FROM分离为计数(后缀Prefix Id)FROM
尝试从以下if
语句中删除分号:
IF ((( SELECT COUNT(suffixPrefixId)FROM tbl_SuffixPrefix WHERE (yearId = p_yearId) AND (voucherType = p_voucherType) ))<>0 );