title: Setting up a trigger in PHPMyAdmin
body: <p>I'm trying to comprehend triggers, and I think I fully understand them, but I haven't been able to implement any of them. I want this code to delete a user with the name "test". So if anyone updates their name to "test" the user should be deleted.</p>
  
  <p>My example code:</p>
  
  <pre><code>CREATE TRIGGER `my_trigger`
  BEFORE UPDATE ON `my_db` FOR EACH ROW
  BEGIN
  DELETE FROM my_table WHERE `username` = 'test';
  END
  </code></pre>
  
  <p>My error:</p>
  
  <pre><code>#1064 - 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 '' at line 4 
  </code></pre>
  
  <p>I can't figure out why the delete statement is giving me an error. Any ideas?</p>