Mysql query: How to ignore errors

[tembil]

Hi,

here's the query that I used I need to know how to ignore errors when executing

LOAD DATA  infile 'myFile12_out.txt'
INTO TABLE itc_db.tbl_address_out
fields
TERMINATED BY '|'
lines
TERMINATED BY '\r\n'
ignore 1 lines;

Please enclose any code within the proper code tags. See the Posting Guidelines on how to do that.

MODERATOR

[ronverdonk]

Hi,

here's the query that I used I need to know how to ignore errors when executing

LOAD DATA  infile 'myFile12_out.txt'
INTO TABLE itc_db.tbl_address_out
fields
TERMINATED BY '|'
lines
TERMINATED BY '\r\n'
ignore 1 lines;

What errors do you want to ignore? Errors are usually issued for some very good reason. Ignoring them could give you an unuseable result.

Ronald