存储过程
DROP PROCEDURE IF EXISTS `库名`.`WJ_TEST`;
CREATE PROCEDURE `库名`.`WJ_TEST` ()
BEGIN
DECLARE i INT DEFAULT 1;
WHILE (i < 100000) DO
INSERT INTO `库名`.edu_test_special_rank (examID,pmID,date,score,isDelete) VALUES(1, i + 129999, now(), 1, 1);
SET i = i + 1;
END
WHILE;
END;
//调用存储过程
CALL `honzh_party`.`WJ_TEST`();