title: update table column after insert new record using MySQL triggers
body: <p>Imagine I have a MySQL table (tbl_test) with these fields: <strong>id, title, priority</strong>.<br>
  <strong>id</strong> will be incremented automatically. I need to fill <strong>priority</strong> field with a value as same as <strong>id</strong> field after inserting.<br>
  As I'm new in using MySQL triggers, please tell me what I have to write for it. I did something , but I think it is not true:  </p>
  
  <pre><code>CREATE TRIGGER 'test' AFTER INSERT ON `tbl_test`
  BEGIN
     SET new.priority = new.id;
  END
  </code></pre>
  
  <p>Thanks for your assistance.</p>