MySQL Forums
Forum List  »  CSV Storage Engine

Re: parsing csv file to analyze insert, update operations
Posted by: Peter Brawley
Date: April 06, 2021 09:49AM

Load Data can't do Updates; it can just do bulk inserts, so your best bet is to Load Data into a temp table, then apply your insert/update logic to that.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: parsing csv file to analyze insert, update operations
14
April 06, 2021 09:49AM


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.