Description:
When using the --delete option of mysqlimport to import multiple files, the delete operation is run before importing each file resulting in only data from the last imported file to be present in the table.
How to repeat:
$ vi test.1.csv
1,1,
2,2,
3,3,
$ vi test.2.csv
4,4,
5,5,
6,6,
$ mysql -e "CREATE DATABASE test; CREATE TABLE test.test(c1 INT, c2 INT);"
$ mysqlimport --delete --local --fields-terminated-by=, --lines-terminated-by="\n" test test.1.csv test.2.csv
test.test: Records: 3 Deleted: 0 Skipped: 0 Warnings: 0
test.test: Records: 3 Deleted: 0 Skipped: 0 Warnings: 0
$ mysql -e "SELECT * FROM test.test;"
+------+------+
| c1 | c2 |
+------+------+
| 4 | 4 |
| 5 | 5 |
| 6 | 6 |
+------+------+
Suggested fix:
While noting that mysqlimport can import multiple files into multiple tables with a single command, thus making the current behavior useful for that scenario, and that there are workarounds for deleting data prior to a load, it would be a nice improvement if the --delete option could keep track of tables that have already been deleted once and not delete them again for every file that loads into those tables. That way, this option could be useful when loading multiple files into one table and have the whole load remain instead of just the last file present on the command prompt.
This feature request could also be implemented with a new flag, ex. --delete-once.
