Hello! I would like to know, whether this task would be doable with HeidiSQL:
I have to import a CSV file into MySQL table. The file and the table have the same structure (columns and types of values). The import goes according to the following algo:
- read a line from the file,
- compare values from column X (file) with column X (db table),
- import line (overwrite db state), if the value in the file is higher, than the value in the db table.