mysql使用存储过程插入测试数据

DELIMITER $$CREATE PROCEDURE ptest()BEGINDECLARE pid INT;SET pid = 10000; 这里输入多少为插入多少条WHILE pid>0 DOINSERT INTO `count`(`name`,age,department)VALUES('测试4',12,4);SET pid = pid-1;                                                                                                                                              END WHILE;END $$DELIMITER ;CALL ptest();