mysql逻辑表达

kider

给你个例子参考：
CREATE DEFINER=`admin`@`%` PROCEDURE `USP_Abc`(v_att INT
    )
SWL_return:
    BEGIN
        SELECT ....
        IF v_at>=v_att THEN
                SELECT -520 AS 'Version';
                LEAVE SWL_return;
        END IF;
        IF EXISTS(SELECT * FROM ttt WHERE ..) THEN
                SELECT ...;
                LEAVE SWL_return;
        END IF;       
    END$$
DELIMITER ;

CREATE PROCEDURE p14 ()
BEGIN
DECLARE v INT;
SET v = 0;
WHILE v < 5 DO
INSERT INTO t VALUES (v);
SET v = v + 1;
END WHILE;
END; //