MySQL Forums
Forum List  »  CSV Storage Engine

parsing csv file to analyze insert, update operations
Posted by: Kaushik Shete
Date: April 05, 2021 11:45PM

I am trying to find some csv parsing mechanism so that it detect insert and update operation to be performed.


id name age operation
1. abc 23 insert
2. xyz 50 insert
3. pqr 45 update
4. efg 20 insert

Above is the csv file structure that I need to parse.

I already have stored procedures for the create and update the records.
Records with id(1,2,4) to be pass to create stored procedure and
id(3) to be pass to update stored procedure.

Options: ReplyQuote

Written By
parsing csv file to analyze insert, update operations
April 05, 2021 11:45PM

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.