title: MySQL Trigger synatax
body: <p>I am trying to create a MySQL trigger to duplicate the auto increment column.</p>
  
  <p>Auto increment column is called "iBmsId" and the duplicate column is called simply "id".</p>
  
  <p>Here is my Query:</p>
  
  <pre><code>CREATE TRIGGER t_bms_ID_Update AFTER INSERT ON t_bms SET id = iBmsId
  </code></pre>
  
  <p>I get the following error in SQL fiddle:</p>
  
  <pre><code>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SET id = iBmsId' at line 1:
  </code></pre>
  
  <p>Any ideas? This is the first time I have used Triggers...</p>