LOAD DATA INFILE

[Nagendra Kolli]

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