load data local infile '~/documents/load_test.txt' into table test fields terminated by ',' enclosed by '' lines terminated by '/n';
1.如果id不是主键，会不停增加。
mysql> load data local infile '~/documents/load_test.txt' into table test fields terminated by ',' enclosed by '' 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 ',' enclosed by '' 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.如果id是主键，会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 ',' enclosed by '' 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)
修改txt文件
mysql> load data local infile '~/documents/load_test.txt' into table test fields terminated by ',' enclosed by '' 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)