weixin_44863365的博客

原创 mysql数据库while循环批量插入数据方法

DROP PROCEDURE IF EXISTS proc_initData; DELIMITER $ CREATE PROCEDURE proc_initData() BEGIN DECLARE i INT DEFAULT 1; WHILE i<=1000 DO这里填你要插入的数据条数 INSERT INTO sm_storage_detail这里填写表名 (storage_head_id, location_id, location_no, location_name, materia