How to accumulate results using mysqlimport

Question

I like mysqlimport, its fast and relatively easy to use (much faster then say, PHP or Python front-ends for importing > 20GB data files). However I'd like to do the following. I have a data file that looks like:

cat dog 7
Cat Dog 3
CaT DOG 1

with the fields as varchar, varchar, int

And I would like the final result to be stored as ['cat', 'dog', 11], i.e. I'd like the result to be inserted into the database if it doesn't exist and added (as in mathematical sense) to the existing one if it does while ignoring the case of the first two fields. I have a working solution in python, but I am looking for a native in mysql(import).

Answer 1

For case sensitivity you could probably downgrade everything into lowercase (there's a function for that). If you want to concatenate it to previous entry, check MySQL string functions.

If you want to insert a record only if it does not exist, check REPLACE or INSERT ON DUPLICATE.