| NUMERIC | STRING | DATE/TIME |
|---|---|---|
| "NULL" | "NULL" | "NULL" |
| NULL | NULL | NULL |
| /N | /N | /N |
| \N | \N | \N |
| "/N" | "/N" | "/N" |
| "\N" | "\N" | "\N" |
The corresponding values that get imported in MYSQL are as follows:
Hence to import NULL values in to MYSQL using import csv method make sure to have entries in CSV file as follows (irrespective of data type) (make sure to make them UPPER CASE):
\N
NULL (Not Recommended)
"\N" (Not Recommended)
