I am using LOAD DATA INFILE, my csv file has 3 columns and the last column has some entries empty, I am running the code.
load data infile 'E:\\PowerBi Tutorial\\SQL Kaggle Porject\\archive\\noc_regions.csv'
into table olympics_history_noc_region
fields terminated by ','
enclosed by '"'
lines terminated by '\r\n'
ignore 1 lines;
So what should I change in this sql query inorder to load all the rows.
The output is showing as : 0 rows affected.
Sample of my CSV file is:
NOC,region,notes
AFG,Afghanistan,
AHO,Curacao,Netherlands Antilles
ALB,Albania,
ALG,Algeria,
AND,Andorra,
ANG,Angola,
