Error 1313: RETURN is only allowed in a function SQL Statement, 1313 allowed

Error 1313: RETURN is only allowed in a function SQL Statement, 1313 allowed

1. Error description

14: 07: 26 Apply changes to rand_stringError 1313: RETURN is only allowed in a function SQL Statement: CREATE PROCEDURE 'rand _ string' (n int) BEGIN DECLARE chars varchar (100) DEFAULT 'duration'; DECLARE return_str varchar (255) DEFAULT ''; DECLARE I int default 0; WHILE I <n DO SET return_str = concat (return_str, substring (chars, FLOOR (1 + RAND () * 52), 1); SET I = I + 1; END WHILE; RETURN return_str; END

2. Error cause

From the above, RETURN can only be used in function SQL statements.

3. Solution

Modify the stored procedure and remove the RETURN value.