title: How to load CSV data into a MySQL database when the raw data being loaded has many unique characters
body: <p>In addition to that, I have to make sure that duplicate tickets are ignored from the new upload when the previous value in the database = <code>'closed', 'completed', 'cancelled', 'rejected'</code>.</p>
  
  <p>Using Programs : <strong>MS Excel 2013, MySQL 6.1 workbench 6.1.7</strong></p>
  
  <p>The column names in <strong>MySQL</strong>:</p>
  
  <pre><code>Column Name Datatype    pk  nn  UQ  BIN UN  ZF  AI  Default
  id          varchar(45)  Y  Y   Y                   
  priority    tinytext                                Null
  submit_dt   datetime                                Null
  group       varchar(100)                            Null
  comp_dt     datetime                                Null
  status      varchar(45)                             Null
  </code></pre>
  
  <p>Raw sample in CSV:</p>
  
  <pre><code>id  priority    submit_dt       group     status    comp_dt
  222 High        1/26/2015 7:08  bread     Closed    1/26/2015 15:23
  333 High        1/26/2015 6:59  drinks    Closed    1/26/2015 13:36
  444 High        1/20/2015 9:09  meat      Completed 1/20/2015 12:32
  555 High        1/13/2015 10:27 salad     Closed    1/13/2015 12:53
  777 High        1/12/2015 11:34 milk      Completed 1/13/2015 8:46
  888 High        1/9/2015 10:29  crackers  Completed 1/9/2015 13:01
  999 High        1/16/2015 14:59 soup      Closed    1/19/2015 12:26
  100 High        1/6/2015 9:05   spices    Closed    1/6/2015 19:11
  </code></pre>