DELIMITER $$ DROP PROCEDURE IF EXISTS test$$ CREATE PROCEDURE test() BEGIN DECLARE v_a INT; DECLARE v_b VARCHAR(10); SELECT aid INTO v_a FROM a; IF v_a=1 THEN SET v_b='b1' ; ELSEIF v_a=2 THEN SET v_b='b1'; ELSE SET v_b='bn'; END IF; INSERT INTO b VALUES(v_a,v_b); END$$ DELIMITER ;
DROP PROCEDURE IF EXISTS test$$
CREATE PROCEDURE test()
BEGIN
DECLARE v_a INT;
DECLARE v_b VARCHAR(10);
SELECT aid INTO v_a FROM a;
IF v_a=1 THEN SET v_b='b1' ;
ELSEIF v_a=2 THEN SET v_b='b1';
ELSE SET v_b='bn';
END IF;
INSERT INTO b VALUES(v_a,v_b);
END$$
DELIMITER ;
Procedure execution failed
1172 - Result consisted of more than one row
检查结果