问题描述
我如何使用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...
推荐答案
这篇关于在MYSQL WORKBENCH中获取声明语法错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！