如何批量新增100万条数据
2020-01-17 本文已影响0人
往后余生9375
新增表
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()
