I am having a CSV file. It holds 1.4 million rows of data, therefore I am not able to open this CSV file in Excel because its limit is about 1 million rows only.
Hence, I need to import this file in MySQL workbench. This CSV file holds columns like:
"Service Area Code","Phone Numbers","Preferences","Opstype","Phone Type"
I am attempting to create a table in MySQL workbench named as "dummy" containing columns like:
The CSV file is named model.csv. My code in the workbench is like this:
LOAD DATA LOCAL INFILE 'model.csv' INTO TABLE test.dummy FIELDS TERMINATED BY ',' lines terminated by '\n';
However, I am getting an error like model.CSV file not found.