title: Syntax error: 'missing semicolon' when creating a MySQL trigger
body: <p>My trigger query:</p>
  
  <pre><code>CREATE DEFINER = CURRENT_USER TRIGGER `test`.`users_AFTER_INSERT` AFTER INSERT ON `users` FOR EACH ROW
  BEGIN
   UPDATE test.users
   SET enabled=1
      FROM Inserted i
      WHERE username = i.username
  END
  </code></pre>
  
  <p>It complains about this part: <code>SET enabled=1</code>. I have tried adding quotes, didn't help. </p>
  
  <p>Most likely the syntax is wrong, but I can't figure out what exactly is wrong here.</p>
  
  <p>EDIT:</p>
  
  <p>Or could it be done like this? </p>
  
  <pre><code>CREATE DEFINER = CURRENT_USER TRIGGER `test`.`users_AFTER_INSERT` AFTER INSERT ON `users` FOR EACH ROW
  BEGIN
   UPDATE test.users
   SET enabled=1
   WHERE username = NEW.username;
  END
  </code></pre>