import CSV file into MySQL database
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?