Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

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

chilly_bang's profile image chilly_bang posted 3 months 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.
ansgar's profile image ansgar posted 3 months 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.