title: MySQL trigger after bulk insert
body: <p>I bulk insert a variable amount of rows in a MySQL table:</p>
  
  <pre><code>INSERT INTO table (col1, col2) VALUES (0,0), (0,1), ..., (0,N)
  </code></pre>
  
  <p>The first column is always the same, the second column changes in every entry. Now I want to implement a MySQL trigger that uses <code>col1</code> to update another table. E.g.</p>
  
  <pre><code>DELIMITER //
  
  CREATE TRIGGER updateOtherTable AFTER INSERT ON table
    FOR EACH ROW BEGIN
      CALL someProcedure(NEW.col1);
    END;
  //
  </code></pre>
  
  <p>However, that would execute <code>someProcedure()</code> <code>N</code> times which is not necessary since <code>col1</code> is always the same for each <code>INSERT</code>.  </p>
  
  <p><strong>Is it possible to call this trigger only once and if so, how?</strong></p>