MYSQL循环存储过程

DROP PROCEDURE
IF EXISTS test_data_subject;

DELIMITER $$
CREATE PROCEDURE test_data_subject()
BEGIN

-- 定义变量
DECLARE i INT UNSIGNED DEFAULT 175;  -- 1是变量可以写10000
-- 循环次数
WHILE i <= 214 DO                                        -- i是变量可以 <10000

insert into intelligencevillage.renthouse_new_examination_subject (examination_id,subject_id) VALUES (28,i);

    SELECT i;
    SET i = i+1;
END WHILE;

END $$

CALL test_data_subject();