DROP PROCEDURE IF EXISTS proc_initData;#如果存在此存储过程则删掉
DELIMITER $
CREATE PROCEDURE proc_initData()
BEGIN
DECLARE i INT DEFAULT 31;
WHILE i<=50 DO
INSERT INTO ds_bus VALUES (i, '12314234123489', NULL, '测试9', NULL, '沙发', '0', 'admin', '2021-10-14 15:05:59', NULL, '2021-10-13 13:32:27', '2021-10-20 11:10:18', 'admin');
SET i = i+1;
END WHILE;
END $
CALL proc_initData();
Mysql模拟插入N条数据
最新推荐文章于 2022-03-22 10:40:18 发布