I am trying to import a CSV file that has a few missing fields. These are represented by ,,
I have checked the CSV file and it looks OK.
When I import, it works fine except that any missing values that are in numerical columns are set to the number 0, which is bad. I need them set to NULL. I have set up the table to use NULL as default. One of the columns in question is created with this command:
GAMING_SCORE FLOAT(3,1) UNSIGNED DEFAULT NULL
Can anyone advise me on how to solve this please?