MySQL Forums
Forum List  »  General

Advanced Search
New Topic

how to ignore invalid row when load data infile?
Posted by: secmask secmask
Date: March 12, 2009 10:08PM

hi all
I need to load data in cvs file into my data table, in cvs file contains some rows that invalid(not has enough field as define in data table), how i can ignore them and continues load next row ?
thanks.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
how to ignore invalid row when load data infile?
secmask secmask
March 12, 2009 10:08PM
Re: how to ignore invalid row when load data infile?
Jay Alverson
March 13, 2009 08:19AM
Re: how to ignore invalid row when load data infile?
secmask secmask
March 14, 2009 07:47PM
Re: how to ignore invalid row when load data infile?
Jay Alverson
March 15, 2009 07:08AM


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.