Question

When the MySQL delimiter error occur?

Answer 1

SET GLOBAL log_bin_trust_function_creators=1;

DROP FUNCTION IF EXISTS digits;

DELIMITER $$

CREATE FUNCTION digits( str CHAR(32) ) RETURNS CHAR(32)

BEGIN

DECLARE i, len SMALLINT DEFAULT 1;

DECLARE ret CHAR(32) DEFAULT '';

DECLARE c CHAR(1);

SET len = CHAR_LENGTH( str );

REPEAT

BEGIN

SET c = MID( str, i, 1 );

IF c BETWEEN '0' AND '9' THEN

SET ret=CONCAT(ret,c);

END IF;

SET i = i + 1;