Import CSV file with preceding comparing of the file and db table

1 posts
chilly_bang's profile image chilly_bang posted 5 years ago in General Permalink

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:

  1. read a line from the file,
  2. compare values from column X (file) with column X (db table),
  3. import line (overwrite db state), if the value in the file is higher, than the value in the db table.
10167 posts
ansgar's profile image ansgar posted 5 years ago Permalink

No, such a special use case is not supported out-of-the-box by HeidiSQL.

Please login to leave a reply, or register at first.