Question

我对我的Sql说得很新。我试图发挥职能:

CREATE FUNCTION GetDefaultLangText(tableName VARCHAR(50), fieldName VARCHAR(50), primaryFieldName VARCHAR(50), langID INT(10), 
                defaultLangID INT(10), itemID INT(10), actValue VARCHAR(200)) RETURNS VARCHAR(200)
BEGIN  
    DECLARE sqlString VARCHAR(200);
    SET sqlString = CONCAT(CONCAT( (SELECT  , fieldName, 
    CONCAT(  FROM  , tableName,   WHERE LangID =  )), CONCAT(defaultLangID ,  AND  , 
    CONCAT(primaryFieldName,   =  , CONCAT(itemID,  ) , NULL))));

    RETURN IF(actValue = NULL OR (CHAR_LENGTH(actValue) = 0), sqlString, actValue);
END;

However this gives me a syntax error can anyone help please ? I m not sure what I m doing wrong since I followed the online documentation

Answer 1

我不认为,如果你只使用“;”作为分离者,就能够工作。

典型的情况是:

DELIMITER 美元

DROP FUNCTION IF EXISTS mytest $$ CREATE FUNCTION mytest () RETURNS INT BEGIN

选择......

插入......

END $$

DELIMITER;

友情链接