How to generate a large amount of Test data in mysql Database

This article mainly introduces "how the mysql database produces a large amount of test data". In the daily operation, I believe that many people have doubts about how the mysql database produces a large number of test data. The editor consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubts of "how the mysql database produces a lot of test data". Next, please follow the editor to study!

1. Create a tabl

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

two。 Create a stored procedure

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 stored procedure

Call proc1 at this point, on the "mysql database how to generate a large number of test data," the study is over, I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!