title: MySQL DELIMITER syntax errors
body: <p>This MySQL script installs multiple triggers. </p>
  
  <p>It works on one machine running MySQL 5.0.51b-community. On another machine running MySQL 14.12 Distrib 5.0.45, for redhat-linux-gnu (i386) it fails, with this error message, which seems to be related to the <code>DELIMITER // ... // DELIMITER</code>; syntax : </p>
  
  <blockquote>
    <p><strong>ERROR 1064 (42000) at line 272: 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 'DELIMITER; DROP TRIGGER IF EXISTS trigger_name; DELIMITER' at line 1</strong></p>
  </blockquote>
  
  <p>The script syntax (summarised) is:</p>
  
  <pre><code>DROP TRIGGER IF EXISTS trigger_name;
  DELIMITER //
  CREATE TRIGGER trigger_name BEFORE UPDATE ON table
  FOR EACH ROW BEGIN
    -- Trigger logic goes here
  END //
  DELIMITER;
  
  -- More trigger drop/create statements follow
  </code></pre>
  
  <p>What is wrong with the script, and how can I correct it?</p>