CODEWITHSUNDEEP
mysqlmysql-workbench
Renish Patel
Renish Patel

Reputation: 262

Declare syntax error in MYSQL Workbench

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';

Upvotes: 7

Views: 9479

Answers (1)

Renish Patel
Renish Patel

Reputation: 262

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.

Upvotes: 11

Related Questions