title: How to import a csv file into MySQL workbench?
body: <p>I have a CSV file. It contain 1.4 million rows of data, so I am not able to open that csv file in Excel because its limit is about 1 million rows. </p>
  
  <p>Therefore, I want to import this file in MySQL workbench. This csv file contains columns like </p>
  
  <pre><code>"Service Area Code","Phone Numbers","Preferences","Opstype","Phone Type"
  </code></pre>
  
  <p>I am trying to create a table in MySQL workbench named as "dummy" containing columns like </p>
  
  <pre><code>ServiceAreaCodes,PhoneNumbers,Preferences,Opstyp,PhoneTyp. 
  </code></pre>
  
  <p>The CSV file is named <code>model.csv</code>. My code in workbench is like this:</p>
  
  <pre><code>LOAD DATA LOCAL INFILE 'model.csv' INTO TABLE test.dummy FIELDS TERMINATED BY ',' lines terminated by '\n';
  </code></pre>
  
  <p>but I am getting an error like <code>model.CSV file not found</code></p>