MySQL Forums
Forum List  »  MySQL & Storage

Import CSV file into the MySQL database
Posted by: Support 2011
Date: August 01, 2012 02:43PM

Hello,

I have records into .CSV file and I want to import them into MySQL database. Whenever I import the .CSV I get the message “Import has been successfully finished…” but only 79 out of 114 records will be inserted into the database. When I try to import the CSV file with 411 records, just 282 will be inserted. The CSV file which got 411 records includes two categories of records “Active and Sold” whereby 114 records are Active. Has someone gotten this type of problem? If so what should be done?

Thanks



Edited 1 time(s). Last edit at 08/01/2012 03:35PM by Support 2011.

Options: ReplyQuote


Subject
Written By
Posted
Import CSV file into the MySQL database
August 01, 2012 02:43PM


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.