在MYSQL WORKBENCH中获取声明语法错误 [英] getting Declare syntax error in MYSQL WORKBENCH

问题描述

我如何使用Declare以及在我的MYSQL WORKBENCH中设置以在新的查询窗口中检查我的storeprocedure输出...



它给出了类似语法错误的错误，意外的Declare_sym ......在第一行有十字标志



我正在使用以下代码..



声明StartDate日期时间



设置StartDate ='2013-07-01';



和我也尝试了第一线的DELIMITER $$，但仍然会出现错误..



请快速帮我吧..它很简单我知道但是我是新的在我的sql中...

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...

推荐答案

在第一行也有但仍然是门控错误..



请快速帮助我..它是如此简单我知道，但我是我的新sql所以...

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...

谷歌搜索后得到我的答案..



Put Declare语句必须在Begin和end语句之间以及它在begin sta之后有第一个语句tement



我从这个精彩的网站上获得了回复......



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

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[^]

这篇关于在MYSQL WORKBENCH中获取声明语法错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！