本人是个菜鸟,在navicat中创建存储过程时遇到的问题
CREATE procedure CountLayer (in node int,out result int)
begin
declare result,lft1, rgt1 int;
if exists(select Node_id from Tree where Node_id = node);
begin
select lft1 = Lft,rgt1 = Rgt from Tree where( Node_id = node);
select result = count(*) from Tree where Lft <= lft1 and Rgt >= rgt1;
end
return result
end
GO
然后错误
[SQL] CREATE procedure CountLayer (in node int,out result int)
begin
declare result,lft1, rgt1 int;
if exists(select Node_id from Tree where Node_id = node);
begin
select lft1 = Lft,rgt1 = Rgt from Tree where( Node_id = node);
select result = count(*) from Tree where Lft <= lft1 and Rgt >= rgt1;
end
return result
end
GO
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ';
begin
select lft1 = Lft,rgt1 = Rgt from Tree where( Node_id = ' at line 4
跪求跪求大神解决。。。