MySQL Forums
Forum List  »  Newbie

Re: Importing .csv duplicates data
Posted by: Rick James
Date: October 09, 2014 08:55PM

Check the mysql table...
Are some rows duplicated?
Are there blank rows? (fix LINES TERMINATED BY...)
Are csv rows split into 2 (or more) mysql rows? (fix LINES TERMINATED Or FIELDS SEPARATED)

Options: ReplyQuote


Subject
Written By
Posted
Re: Importing .csv duplicates data
October 09, 2014 08:55PM


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.