MySQL—利用存储过程批量增加测试数据

delimiter //  将结束语句临时设置为//结束

DROP PROCEDURE IF EXISTS test_batch_insert;
CREATE PROCEDURE test_batch_insert()
BEGIN
	DECLARE i BIGINT;
	DECLARE j BIGINT;
	DECLARE tel BIGINT;
	DECLARE card BIGINT;
	SET i=0;
	SET j=10000000;
	SET tel=17600000000;
	SET card=410822199912110000;
	WHILE i <= 10000 DO
	INSERT INTO student (`student_num`, `name`, `sex`, `native_place`, `nation`, `birthdate`, `enter_day`, `phone`, `email`, `addr`, `politics`, `major`, `room`, `card_num`) VALUES((j+1),CONCAT('王武',i+1),1,'河南郑州','汉','1999-03-01 18:20:21','2019-05-12 18:24:45',(tel+1),CONCAT(j+1,'@qq.com'),CONCAT('河南郑州金水区',i+1),'党员','机械工程','101',(card+1));
	SET i=i+1;
	SET j=j+1;
	SET card=card+1;
	SET tel=tel+1;
	END WHILE;
END //
 
delimiter ;  改回; 结束
call proc_batch_insert();   运行函数

效果展示：