<div>
Ahh! &nbsp;I thought I could any time wihin a BEGIN ... END.<br />
<br />
Thanks. I'll try a procedure ...<br />

</div>


Ahh!  I thought I could any time wihin a BEGIN ... END.

Thanks. I'll try a procedure ...


<div>
<div class="content wysiwyg-content">
Where's my DECLARE going wrong?<br />
<a href="http://dev.mysql.com/doc/refman/5.0/en/declare.html" rel="ugc">http://dev.mysql.com/doc/refman/5.0/en/declare.html</a><br />
<br />
After a Delimiter $$<br />
<br />
mysql&gt; BEGIN Declare i INT; set i = &nbsp;0; END$$<br />
ERROR 1064 (42000): 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 i INT; set i = &nbsp;0; END' at line 1
</div>
</div>


Where's my DECLARE going wrong?
http://dev.mysql.com/doc/refman/5.0/en/declare.html

After a Delimiter $$

mysql> BEGIN Declare i INT; set i =  0; END$$
ERROR 1064 (42000): 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 i INT; set i =  0; END' at line 1

MySQL DECLARE Syntax Error

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.