问题代码:
DELIMITER //
CREATE PROCEDURE test8()
BEGIN
DECLARE i INT;
DECLARE v ITN;
SET i=0;
WHILE i < 10 DO
SET v=i+2;
INSERT INTO test(`name`) VALUES (v);
i=i+1;
END WHILE;
END;
//
DELIMITER ;
下面的代码执行均成功:
DELIMITER //
CREATE PROCEDURE test6()
BEGIN
DECLARE v INT;
SET v =34;
INSERT INTO test(`name`) VALUES (v);
END;
//
DELIMITER ;
DELIMITER //
CREATE PROCEDURE test7()
BEGIN
DECLARE v INT;
SET v = 0';
WHILE v<5 DO
INSERT INTO test(`name`) VALUES (v);
END WHILE;
END;
//
DELIMITER ;