Catalog

1、 Create test table

2、 Create stored procedure

3、 Calling stored procedure

1、 Create test table

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for one_data
-- ----------------------------
DROP TABLE IF EXISTS `one_data`;
CREATE TABLE `one_data`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT ' Primary key ID',
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT ' name ',
  `sort_number` int(11) NULL DEFAULT NULL COMMENT ' Serial number ',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT ' Creation time ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = ' Test batch insert data ' ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;

2、 Create stored procedure

--  Create stored procedure 
CREATE  PROCEDURE `addOneData`(IN n int) 
BEGIN
    DECLARE i INT DEFAULT 1;
	WHILE (i <= n ) DO
		INSERT INTO `one_data`( `name`, `sort_number`, `create_time`) VALUES (CONCAT(' Data name ',i), i, NOW());
		set i=i+1;
	END WHILE;
END

3、 Calling stored procedure

--  call   This is insert 1000 strip 
CALL addOneData(1000)