MYSQL中的语法错误'；1064'； - syntax error in MYSQL '1064'

syntax error in MYSQL '1064'

本文关键字：1064 错误语法 MYSQL | 更新日期: 2023-09-27

我无法找出以下查询的语法错误。。帮助帮助帮助

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 );