title: MySQL bulk INSERT or UPDATE
body: <p>Is there any way of performing in bulk a query like <code>INSERT OR UPDATE</code> on the MySQL server?</p>
  
  <pre><code>INSERT IGNORE ...
  </code></pre>
  
  <p>won't work, because if the field already exists, it will simply ignore it and not insert anything.</p>
  
  <pre><code>REPLACE ...
  </code></pre>
  
  <p>won't work, because if the field already exists, it will first <code>DELETE</code> it and then <code>INSERT</code> it again, rather than updating it.</p>
  
  <pre><code>INSERT ... ON DUPLICATE KEY UPDATE
  </code></pre>
  
  <p>will work, but it can't be used in bulk.</p>
  
  <p>So I'd like to know if there's any command like <code>INSERT ... ON DUPLICATE KEY UPDATE</code> that can be issued in bulk (more than one row at the same time).</p>