getting Declare syntax error in MYSQL WORKBENCH

Question

1.00/5 (1 vote)

See more:

How can i used Declare as well as set in my MYSQL WORKBENCH for checked my storeprocedure output in new Query window...

It give error like Syntax error, unexpected Declare_sym...at first line with cross sign

I am using following code for it..

Declare StartDate datetime

set StartDate = '2013-07-01';

and i also tried DELIMITER $$ at first line also but still gating errors..

Please help me fast for it.. it is so simple i know but i am new in my sql so...

Posted 19-Jul-13 21:11pm

renish patel

Updated 28-Oct-21 21:56pm

Add a Solution

2 solutions

Solution 2

DROP PROCEDURE IF EXISTS `PROCEDURENAME`;
DELIMITER$$
CREATE PROCEDURE `PROCEDURENAME`()
BEGIN
DECLARE

SET
END $$
DELIMITER;

Follow the above pattern

Posted 28-Oct-21 21:56pm

Member 15411927

Comments

CHill60 29-Oct-21 4:10am

You have added nothing to the solution that was posted here 8 years ago. If you are going to answer ancient questions please ensure that you are bringing something new to the thread - or stick to newer questions where the OP still needs help

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

renish patel · Accepted Answer · 2013-07-19T21:37:00

Solution 1

after googling i get my answer..

Put Declare statement must in between Begin and end statement as well as it has first statement after begin statement

I getting ans from this wonderful site..

http://dev.mysql.com/doc/refman/5.0/en/declare.html[^]

Posted 19-Jul-13 21:37pm

renish patel