MySQL quickly inserts 100 million test data

CREATE TABLE `t_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `c_user_id` varchar(36) NOT NULL DEFAULT '' COMMENT 'User Id',
  `c_name` varchar(22) NOT NULL DEFAULT '' COMMENT 'User name',
  `c_province_id` int(11) NOT NULL COMMENT 'Province Id',
  `c_city_id` int(11) NOT NULL COMMENT 'City Id',
  `create_time` datetime NOT NULL COMMENT 'Creation time',
  PRIMARY KEY (`id`),
  KEY `idx_user_id` (`c_user_id`)
)ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE `tmp_table` (
  `id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
)ENGINE=InnoDB DEFAULT CHARSET=utf8; 

python -c "for i in range(1, 1+100000000): print(i)" > base.txt 

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
 
mysql> use test;
Database changed
mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| student |
| t_user |
| tmp_table |
+----------------+
3 rows in set (0.00 sec)

mysql> load data infile 'E:/base.txt' replace into table tmp_table;
ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option 
so it cannot execute this statement
mysql>

mysql> show variables like '%secure%';
+--------------------------+-------+
| Variable_name | Value |
+--------------------------+-------+
| require_secure_transport | OFF |
| secure_auth | ON |
| secure_file_priv | NULL |
+--------------------------+-------+
3 rows in set, 1 warning (0.00 sec)

secure_file_prive=null Restrict mysqld from importing and exporting secure_file_priv=/var/lib/mysql-files/ Restrict mysqld importing and exporting to the /var/lib/mysql-files/ directory secure_file_priv=' ' Do not restrict mysqld importing and exporting

mysql> use test;
Database changed
mysql> show variables like '%secure%';
+--------------------------+-------+
| Variable_name | Value |
+--------------------------+-------+
| require_secure_transport | OFF |
| secure_auth | ON |
| secure_file_priv | E:\ |
+--------------------------+-------+
3 rows in set, 1 warning (0.00 sec)

mysql> load data infile 'E:/base.txt' replace into table tmp_table;
Query OK, 100000000 rows affected (3 min 53.42 sec)
Records: 100000000 Deleted: 0 Skipped: 0 Warnings: 0
 
mysql>

mysql> UPDATE t_user SET create_time=date_add(create_time, interval FLOOR(1 + (RAND() * 7)) year);
Query OK, 100000000 rows affected (7 min 24.17 sec)
Rows matched: 100000000 Changed: 100000000 Warnings: 0
 
mysql> UPDATE t_user SET create_time=date_add(create_time, interval FLOOR(1 + (RAND() * 7)) year);
Query OK, 100000000 rows affected (8 min 2.49 sec)
Rows matched: 100000000 Changed: 100000000 Warnings: 0