title: I have a trigger on one of my tables and I want to use it on another table but it won't work
body: <p>I have a before insert trigger on one table. What it does is the following:
  place a string and some zeros before the id and add it to <code>deelnemers</code> table. Now I have a second table (in the same database) and I copy pasted the same trigger there but it won't work. All I get are zeros as entries in de 'deelnemernr' column. For the first table it works perfectly by the way. Here is my trigger code:</p>
  
  <pre><code>BEGIN
  INSERT INTO deelnemers_seq VALUES (NULL);
  SET NEW.deelnemernr = CONCAT('lol16', LPAD(LAST_INSERT_ID(), 3, '0'));
  END
  </code></pre>