How can I declare and set a variable in my MYSQL WORKBENCH
in a stored procedure?
It gives a syntax error like unexpected Declare_sym
at the first line with a cross sign.
I am using the following code for it:
Declare StartDate datetime
set StartDate = '2013-07-01';
After some googling, I got my answer.
A Declare
statement must be in between Begin
and End
statement. Additionally, it must be the first statement after the Begin
statement.
I got the answer from this wonderful site.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With