hugh 的个人博客

DELIMITER $$ //定义分界符 $$
DROP PROCEDURE IF EXISTS `test`$$
CREATE PROCEDURE `test`()
 BEGIN
    DECLARE i INT DEFAULT 100000;
    DECLARE j INT DEFAULT 200;
    WHILE (i <= 150000) DO
        INSERT INTO `t1` (`name`, `age`, `sex`) VALUES (i, 20, '1');
        SET i = i + 1;
        SET j = j + 1;         
        IF MOD(i,1000)=0 THEN COMMIT;
        END IF;    
    END WHILE;
 END$$
DELIMITER ;
CALL test();