MySQL Forums
Forum List  »  Docs

LOAD DATA INFILE
Posted by: Nagendra Kolli
Date: August 27, 2015 03:21AM

Hi,

I have flat file delimited by $ with 2 million records. One the field in the file has length of 500(AN AlphaNumeric). But the table to which I am loading only allows upto 250 characters.

I am using LOAD DATA INFILE and calling the below command from a shell script.

mysql -u<user> -p<passwdrd> <db> -e "load data infile <table_name> lines delimited by '$' terminated by '\n' ignore 1 lines "


I am want skip those records and continue loading the rest of rows in to the table.


In oracle SQL*loader, such kind of records will be pushed to bad file and it will continue execution.


I need to know the keyword (or) option to ignore the errors lines and continue in MySQL using LOAD DATA INFILE


Thanks in advance, It would be a great help if anyone provide the solution for this

Cheers,
Nagendra Reddy K

Options: ReplyQuote


Subject
Views
Written By
Posted
LOAD DATA INFILE
3031
August 27, 2015 03:21AM
1486
September 29, 2015 12:20PM


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.