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 11 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 11 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.




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.