MySQL Forums
Forum List  »  MySQL Workbench

CSV import after comparison of file with db
Posted by: Evgeniy Orlov
Date: October 29, 2019 11:34AM

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?

Options: ReplyQuote


Subject
Views
Written By
Posted
CSV import after comparison of file with db
53
October 29, 2019 11:34AM


Sorry, only registered users may post in this forum.

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.