MySQL 函数 REPLACE 抛出语法错误

Question

我创建了一个在我的数据库中工作的函数，但是我正在使用的 IDE 生成的该函数的 CREATE 代码 ( HeidiSQL ) 抛出错误:

Erro SQL (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 '' at line 10

生成的代码如下:

CREATE DEFINER=`root`@`localhost` FUNCTION `CONVERTE_VALOR`(`VALOR` VARCHAR(255))
    RETURNS decimal(10,0)
    LANGUAGE SQL
    NOT DETERMINISTIC
    NO SQL
    SQL SECURITY DEFINER
    COMMENT 'Converte valor VARCHAR em DECIMAL para comparação'
BEGIN

    RETURN CAST(REPLACE(REPLACE(VALOR, '.', ''), ',', '.') AS UNSIGNED); /* Line 10 */

END

有什么建议吗？

Answer 1

尝试:

CREATE DEFINER=`root`@`localhost` FUNCTION `CONVERTE_VALOR`(`VALOR` VARCHAR(255))
    RETURNS decimal(10,0)
    LANGUAGE SQL
    NOT DETERMINISTIC
    NO SQL
    SQL SECURITY DEFINER
    COMMENT 'Converte valor VARCHAR em DECIMAL para comparação'
-- BEGIN
    RETURN CAST(REPLACE(REPLACE(VALOR, '.', ''), ',', '.') AS UNSIGNED); /* Line 10 */
-- END