CSV import after comparison of file with db
I have to import a CSV file into MySQL table. The file and the table have the same structure (columns and types of values). Is it possible to accomplish this import using Workbench, if 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
Is there any option to run a query on import or to adjust an import wizard anyhow to do such comparison?
Subject
Views
Written By
Posted
CSV import after comparison of file with db
1329
October 29, 2019 11:34AM
468
October 29, 2019 01:21PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.