Error 1313: RETURN is only allowed in a FUNCTION SQL Statement，1313allowed

Error 1313: RETURN is only allowed in a FUNCTION SQL Statement，1313allowed

1、錯誤描述

14:07:26Apply 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 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ';                 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、錯誤原因

    由上述可知，RETURN僅僅只能在函數SQL語句裡用

3、解決辦法

    修改預存程序，去掉RETURN值