title: LOAD FILE INTO TABLE...0 rows affected
body: <p>I have tried to load a <code>.csv</code> file into mysql in many different ways. I have most recently tried</p>
  
  <pre><code>load data local infile 'c:\Users\...csv' into table suppression_list;
  </code></pre>
  
  <p>which works, but I'm told <code>0 rows affected</code>.</p>
  
  <p>I've tried to drop the <code>local</code> but then it says the file is not found. I've tried to add <code>lines terminated by ...</code> and <code>fields terminated by ...</code> but that doesn't seem to make any difference. I've also tried saving the file as <code>.txt</code> but with no luck. <code>suppression_list</code> is just one column, <code>email text</code>.</p>
  
  <p>Here is a snapshot of my data</p>
  
  <pre><code>覧覧覧覧覧
  覧覧覧覧覧
  #
  # Contacts
  *****@une.net.co
  .australia@gmail.com
  .d.yncly.d.ay@gmail.com
  .dy.n.cly.d.a.y@gmail.com
  .je.n.i.s.di.ken.s.o.n.1@gmail.com
  .jell.yhe.a.d1.2.12@gmail.com
  </code></pre>
  
  <p>You can see it's just one column of email addresses, some of which look a little funky, I'll admit.</p>