1.3 mysql batch insert data

DROP PROCEDUREIF EXISTS test_data;DELIMITER $$ //delimiterCREATE PROCEDURE test_data()BEGIN-- define variablesDECLARE i INT UNSIGNED DEFAULT 1; -- define the default value of variable i-- CyclesWHILE i <= 1000 DO -- loopINSERT INTO testdata_check(id,crawl_cfg_id,detection_type,crawl_file_info_id,task_instance_id,crawl_content) VALUES(CONCAT('17ac3e7419954b63878157491a4e8d42',i),'2','5',null,'1f9d7b13c0174dc0afa52f00a5: "http:d7b13c0174dc0afa52f00a5"//www.beijing.gov.cn/shipin/Interviewlive/558.html", "title": "Beijing Press Conference on Novel Coronavirus Pneumonia Epidemic Prevention and Control (Session 253)", "author": "", "domain": "beijing.gov.cn", "islist": "False", "content": "Resetrestore all settings to the default values", "send_time": "2022-07-29 17:32:52", "create_time": "2022-07-29 17:32:52", "islist_code": 0.1447209933229973, "publish_time": "2021-11-01"}');SET i = i+1; -- update the value of iEND WHILE; -- end the loopEND $$--CALL test_data();