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.

a.csv

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


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


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.