DELIMITER $$
CREATE PROCEDURE ptest()
BEGIN
DECLARE pid INT;
SET pid = 10000; 这里输入多少为插入多少条
WHILE pid>0 DO
INSERT INTO `count`(`name`,age,department)VALUES('测试4',12,4);
SET pid = pid-1;
END WHILE;
END $$
DELIMITER ;
CALL ptest();
mysql使用存储过程插入测试数据
最新推荐文章于 2022-08-24 20:26:40 发布