-- 生成个函数
DELIMITER #
CREATE PROCEDURE insert_10000 ()
BEGIN
DECLARE
i INT DEFAULT 1 ;
WHILE i <= 10 DO
INSERT INTO tmp_test_ids (`id`) values(i) ;
SET i = i + 1 ;
END WHILE ; COMMIT ;
END #
call insert_10000()