sql issues

Mysql Workbench doesn't import all rows from CSV to table

I was trying to import the contents from CSV file to a MySQL table while using MySQL workbench. Interestingly, it just won't import all the rows which were in the CSV file.

Things I tried -

1. Try keeping only 3 columns and then try importing -- all rows successfully got imported

2. Removed few columns which were having dashes as values and not null. Removing those and then trying importing the csv again led to import of lesser no. of rows.

3. Searching for any problematic values in the columns which could be making MySQL to skip the rows.

Moments