title: mysql workbench, replace column from file
body: <p>I have a 1,000,000 row .csv file that I uploaded into a table using mySQL Workbench, but I forgot to makes the dates <code>YYYY-MM-DD</code> before I started, so they all uploaded as <code>0000-00-00</code>.</p>
  
  <p>It took almost 8 hours to upload the million records, so I'd REALLY like to not have to do it all over again, but I can't figure out if there's a way for me to replace JUST that one column of data from the same file I originally uploaded, now that I've changed the dates to be in the correct format.</p>
  
  <p>Does anyone know if this is possible?</p>
  
  <p><strong>Edit</strong></p>
  
  <p>It's WAY too long to post everything, but:  here's the <code>show create table</code> with some of the meat taken out:  </p>
  
  <pre><code>CREATE TABLE myTable
  (   lineID int(11) NOT NULL AUTO_INCREMENT,
      1 varchar(50) DEFAULT NULL,
      2 varchar(1) DEFAULT NULL,
      3 int(4) DEFAULT NULL,
      4 varchar(20) DEFAULT NULL,
      DATE date DEFAULT NULL,
      PRIMARY KEY (lineID)
  ) ENGINE=InnoDB AUTO_INCREMENT=634205 DEFAULT CHARSET=utf8
  </code></pre>
  
  <p>Version is <strong>5.6.20</strong></p>
  
  <p>Screenshot:
  <a href="https://i.stack.imgur.com/UflNE.png" rel="noreferrer"><img src="https://i.stack.imgur.com/UflNE.png" alt="enter image description here"></a></p>