title: Will MySQL InnoDB ON UPDATE CASCADE constraints update properly during a MySQL REPLACE command?
body: <p>If I have table B with foreign key references to table A (set to ON UPDATE CASCADE) and I run a </p>
  
  <pre><code>LOAD DATA INFILE file.txt REPLACE INTO TABLE A;
  </code></pre>
  
  <p>command, will the references update properly?</p>
  
  <p>Please note that I'm not talking about ON DELETE CASCADE; I know a REPLACE command will delete records in table B if I have that set.</p>