MySQL 存储过程中不继续执行下面的SQL时可以用 LEAVE LABEL_PROC;
LABEL_PROC:
BEGIN
IF p_state = '' THEN
SELECT -2501035 AS return_code, 'state error' AS return_msg;
LEAVE LABEL_PROC;
END IF;
END LABEL_PROC //
LABEL_PROC:
BEGIN
IF p_state = '' THEN
SELECT -2501035 AS return_code, 'state error' AS return_msg;
LEAVE LABEL_PROC;
END IF;
END LABEL_PROC //