MySQL create function時(shí)報(bào)錯(cuò)

發(fā)布時(shí)間：2020-08-16 11:32:47 來(lái)源：ITPUB博客閱讀：433 作者：feelpurple 欄目：MySQL數(shù)據(jù)庫(kù)

MySQL create function時(shí)報(bào)錯(cuò)
mysql> delimiter $$
mysql> CREATE FUNCTION is_ChangeDescColumnExist (THE_VERSION_LEVEL_TABLE_NAME VARCHAR(35)) RETURN INT DETERMINISTIC
    ->     BEGIN
    -> DECLARE nbr INT;
    ->     SET nbr =0;
    -> /*        DECLARE CONTINUE HANDLER FOR NOT FOUND RETURN 0;*/
    ->         select count(*) into nbr from information_schema.columns where table_name = THE_VERSION_LEVEL_TABLE_NAME and
    ->         (column_name ='C_CHANGE_DESCRIPTION');
    ->         IF nbr = 1 THEN
    ->             RETURN 1;
    ->         ELSE
ELSE    ELSEIF
    ->         ELSE
    ->             RETURN 0;
    ->         END IF;
    ->     END$$
ERROR 1064 (42000): 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 'RETURN INT DETERMINISTIC
    BEGIN
DECLARE nbr INT;
    SET nbr =0;

        sel' at line 1

報(bào)錯(cuò)原因：
RETURN INT DETERMINISTIC語(yǔ)句中返回關(guān)鍵字應(yīng)該是RETURNS

修改后，創(chuàng)建函數(shù)正常
delimiter $$
CREATE FUNCTION is_ChangeDescColumnExist (THE_VERSION_LEVEL_TABLE_NAME VARCHAR(35)) RETURNS INT DETERMINISTIC
    BEGIN
   DECLARE nbr INT;
    SET nbr =0;
/*        DECLARE CONTINUE HANDLER FOR NOT FOUND RETURN 0;*/
        select count(*) into nbr from information_schema.columns where table_name = THE_VERSION_LEVEL_TABLE_NAME and
        (column_name ='C_CHANGE_DESCRIPTION');
        IF nbr = 1 THEN
            RETURN 1;
        ELSE
            RETURN 0;
        END IF;
    END$$

向AI問(wèn)一下細(xì)節(jié)

MySQL create function時(shí)報(bào)錯(cuò)

猜你喜歡

最新資訊

相關(guān)推薦

相關(guān)標(biāo)簽