title: mysql LOAD DATA INFILE not working
body: <p>I am trying to use mysql LOAD DATA INFILE on command line to load csv file. It neither gives any error nor it loads any data. Can anyone please help me out? I am using following command</p>
  
  <pre><code>mysql&gt; LOAD DATA INFILE '/Applications/XAMPP/xamppfiles/htdocs/dev/__php__/mysql/data.csv'
  -&gt;             INTO TABLE csvdata
  -&gt;               FIELDS TERMINATED BY ','
  -&gt;               OPTIONALLY ENCLOSED BY '"'
  -&gt;               LINES TERMINATED BY '\n'
  -&gt;               IGNORE 1 LINES;
  Query OK, 0 rows affected (0.00 sec)
  Records: 0  Deleted: 0  Skipped: 0  Warnings: 0
  </code></pre>
  
  <p>Following is my CSV file</p>
  
  <pre><code>"emp_id","first_name","last_name","username"
  "EMP1","Tibass","Deloris","Tibass1"
  </code></pre>
  
  <p>Regards</p>