MySQL Forums
Forum List  »  Italian

load data infile how manage errors
Posted by: Noemi Nocioni
Date: May 21, 2014 07:13AM

Hi all,
I'm using LOAD DATA INFILE to load a csv file into mysql table. When an error occur I have two possibility ( by documentation):

1. Change errors in warnings and continue loading file ( including lines generating the warnings)
2. Maintain errors, skip line generation errors and stop loading procedure

There's a way to skip lines with error and continue loading procedure? I need some kind of oracle sqlldr.

Any help will be appreciated.

Options: ReplyQuote


Subject
Views
Written By
Posted
load data infile how manage errors
1947
May 21, 2014 07:13AM


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.