Mysqlload primary key verification _ MySQL

Mysqlload primary key verification load data LOCAL infile '~ /Documents/load_test.txt 'into TABLE test fields terminated by', 'enabledby '"'lines TERMINATED by'/N ';

1. if the id is not the primary key, it will not stop increasing.
Mysql> load data LOCAL infile '~ /Documents/load_test.txt 'into TABLE test fields terminated by', 'enabledby '"'lines TERMINATED by'/N ';
Query OK, 2 rows affected (0.02 sec)
Records: 2 Deleted: 0 Skipped: 0 Warnings: 0

Mysql> select * from test;
+ ------ + ----------- +
| Id | name |
+ ------ + ----------- +
| 1 | wang |
| 2 | xia |
| 3 | wang-load |
| 4 | xia-load |
+ ------ + ----------- +
4 rows in set (0.00 sec)

Mysql> load data LOCAL infile '~ /Documents/load_test.txt 'into TABLE test fields terminated by', 'enabledby '"'lines TERMINATED by'/N ';
Query OK, 2 rows affected (0.04 sec)
Records: 2 Deleted: 0 Skipped: 0 Warnings: 0

Mysql> select * from test; + ------ + ----------- +
| Id | name |
+ ------ + ----------- +
| 1 | wang |
| 2 | xia |
| 3 | wang-load |
| 4 | xia-load |
| 3 | wang-load |
| 4 | xia-load |
+ ------ + ----------- +
6 rows in set (0.00 sec)


2. if id is the primary key, it will skip
Mysql> alter table test add primary key (id );
Query OK, 2 rows affected (0.38 sec)
Records: 2 Duplicates: 0 Warnings: 0

Mysql> select * from test; + ---- + ------ +
| Id | name |
+ ---- + ------ +
| 1 | wang |
| 2 | xia |
+ ---- + ------ +
2 rows in set (0.00 sec)

Mysql> load data LOCAL infile '~ /Documents/load_test.txt 'into TABLE test fields terminated by', 'enabledby '"'lines TERMINATED by'/N ';
Query OK, 2 rows affected (0.05 sec)
Records: 2 Deleted: 0 Skipped: 0 Warnings: 0

Mysql> select * from test; + ---- + ----------- +
| Id | name |
+ ---- + ----------- +
| 1 | wang |
| 2 | xia |
| 3 | wang-load |
| 4 | xia-load |
+ ---- + ----------- +
4 rows in set (0.00 sec)



Modify a TXT file
Mysql> load data LOCAL infile '~ /Documents/load_test.txt 'into TABLE test fields terminated by', 'enabledby '"'lines terminated by'/N'; Query OK, 0 rows affected (0.00 sec)
Records: 2 Deleted: 0 Skipped: 2 Warnings: 0

Mysql> select * from test; + ---- + ----------- +
| Id | name |
+ ---- + ----------- +
| 1 | wang |
| 2 | xia |
| 3 | wang-load |
| 4 | xia-load |
+ ---- + ----------- +
4 rows in set (0.00 sec)