Suppose you have a comma-delimited file named city.csvthat you need to load into a table called city. The file delimiter is a comma, text is enclosed with double-quotes, and each line is ends with a newline character.
Given this situation, what would the correct load data infile statement look like?
A.
LOAD DATA INFILE ‘city.csv’ INTO TABLE City
FIELDS TERMINATED BY ‘, ‘ OPTIONALLY ENCLOSED BY “” LINES TERMINATED BY ‘\n’
B.
LOAD DATA INFILE ‘city.csv’ INTO TABLE City
COLUMNS TERMINATED BY ‘, ‘ OPTIONALLY ENCLOSED BY “” LINES TERMINATED BY ‘\n’
C.
LOAD DATA INFILE ‘city.csv’ INTO TABLE City
FIELDS TERMINATED BY ‘,’ TEXT ENCLOSED BY “” LINES TERMINATED BY ‘\n’ D LOAD DATA INFILE ‘city.csv’ INTO TABLE City
COLUMNS TERMINATED BY ‘,’ TEXT ENCLOSED BY ‘”‘ LINES TERMINATED BY ‘\n’