如何优雅添加百万数据到数据库方案一

‘''
CREATE TABLE ods_530000_001_330pc (
name varchar(300) DEFAULT NULL,
sex varchar(300) DEFAULT NULL,
phone varchar(300) DEFAULT NULL,
area varchar(300) DEFAULT NULL,
work_id int(11) DEFAULT NULL,
OPT_TIME varchar(300) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

'''

'''

CREATE PROCEDURE auto_insert4()
BEGIN
DECLARE i INT DEFAULT 1;
WHILE (i <= 10000 ) DO
INSERT INTO xian_test_data.dwd_530000_001_330pc (name,sex,phone,area,work_id,OPT_TIME) VALUES('李白','男','13456997','城市',1,'2022-03-31');
set i=i+1;
END WHILE;
END

call auto_insert4();

'''