title: How to create a MySQL trigger in phpmyadmin
body: <p>I want to create a trigger in MySQL.  I run following commands:</p>
  
  <pre><code>mysql&gt; delimiter //
  mysql&gt; CREATE TRIGGER before_insert_money BEFORE INSERT ON money
      -&gt; FOR EACH ROW
      -&gt; BEGIN
      -&gt; UPDATE accounts SET balance=10.0;
      -&gt; END;
      -&gt; //
  Query OK, 0 rows affected (0.19 sec)
  </code></pre>
  
  <p>But when I run above SQL in phpmyadmin I get this 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>what's wrong here?  How do I create a trigger?</p>