I have a table which has four fields
create table test_hc1(cola int,colb int,colc varchar(20),cold int);
Now, I am trying to load following data
and the third field in table is coming out as NULL, which is the expected result.
In another case, I am trying to load following data
and it is also loading the third field as NULL.
Here is my question : What is the difference between using the two(\N, NULL) ?
I am using
LOAD DATA LOCAL INFILE 'PATH_TO_DATAFILE' INTO TABLE TABLE_NAME FIELDS TERMINATED BY x'01';
Any help is appreciated.