Re: How to declare a variable in a script

[Peter Brawley]

MySQL doesn't follow Microsoft SQL dialect syntax.

1 MySQL supports begin...end and other such block constructs only in stored routines & Triggers.

2 System vars are referenced with 2 @ prefixes. Set system vars with SET, not with DECLARE, which is also supported only in stored routines & Triggers.

Declare and set user vars with SET, using just one @ prefix, eg ...

set @count=2;