title: Why do SQL declare fail?
body: <p>I have this piece of code:</p>
  
  <pre><code>BEGIN
      DECLARE @NewLine CHAR(2)
      SET @NewLine = CHAR(13)+CHAR(10)
  END
  </code></pre>
  
  <p>When I run it 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 'DECLARE @NewLine CHAR(2) SET @NewLine = CHAR(13) + CHAR(10) END' at line 2
  </code></pre>
  
  <p>I used about 2 hours on Google, without any luck. As far as I can tell, it should be the right syntax.
  Someone please help</p>