How to Use return in the mysql Stored Procedure

As we all know, mysql stored procedures cannot use the return statement. Only storage functions have this function. Is there any keyword that replaces return? No! No keywords like exit or quit! What should I do? Use the leave keyword, which can mimic the return behavior. For example, SET FOREIGN_KEY_CHECKS = 0; -- export Procedure structure for sp_test_return -- ------------------------------ drop procedure if exists 'SP _ test_return '; DELIMITER ;; create procedure 'SP _ test_return '(In num integer) label_pro: begin www.2cto. comif num> 3 then leave label_pro; else select num as exeuted; end if; end; DELIMITER; in this example, the entry of the entire stored procedure is marked, when you need to exit the stored procedure, as long as the leave + mark is Yes.
Author crocodile