如何批量新增100万条数据

新增表

CREATE TABLE `tb_order` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(20) DEFAULT NULL,
  `order_number` varchar(32) DEFAULT NULL,
  `order_type` tinyint(1) unsigned DEFAULT NULL,
  `amount` decimal(10,2) NOT NULL,
  `create_date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_order_number` (`order_number`) USING HASH
) ENGINE=InnoDB AUTO_INCREMENT=201643 DEFAULT CHARSET=utf8mb4;

创建存储过程

BEGIN

SET @num = 1;
WHILE
@num < 1000000 DO

INSERT INTO tb_order(name,order_number,order_type,amount,create_date)VALUES('订单',REPLACE ( UUID( ), '-', '' ),1,10.00,now());

SET @num = @num + 1;

END WHILE;

END

执行

call newOrder()