mysql产生大量数据_mysql数据库产生大量测试数据

1. 创建表

CREATE TABLE `user` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,

`age` int(11) DEFAULT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

2. 创建存储过程

DROP PROCEDURE IF EXISTS proc1;

DELIMITER $$

SET AUTOCOMMIT = 0$$

CREATE PROCEDURE proc1()

BEGIN

DECLARE v_cnt DECIMAL (10) DEFAULT 0 ;

dd:LOOP

INSERT INTO USER ( NAME, age ) VALUES ( UUID( ), RIGHT ( v_cnt, 1 ) );

COMMIT;

SET v_cnt = v_cnt+1 ;

IF v_cnt = 10000000 THEN LEAVE dd;

END IF;

END LOOP dd ;

END;$$

DELIMITER ;

3. 调用存储过程

call proc1