MySQL mysqlimport Handling duplicate keys
Example
Given the table Employee
| id | Name |
|---|---|
| 3 | Yooden Vranx |
And the file employee.txt
1
\tArthur Dent
2\tMarvin
3\tZaphod Beeblebrox
The --ignore option will ignore the entry on duplicate keys
$ mysqlimport --ignore mycompany employee.txt
| id | Name |
|---|---|
| 1 | Arthur Dent |
| 2 | Marvin |
| 3 | Yooden Vranx |
The --replace option will overwrite the old entry
$ mysqlimport --replace mycompany employee.txt
| id | Name |
|---|---|
| 1 | Arthur Dent |
| 2 | Marvin |
| 3 | Zaphod Beeblebrox |
