CREATE function dzz_down(@tfid varchar(100))/*定义函数c_tree,输入参数为初始节点id*/ returns @t table(tfid varchar(100),pid varchar(100),lev int)/*定义表t用来存放取出的数据*/ begin declare @i int/*标志递归级别*/ set @i=1 insert @t select tfid,pid,@i from tbl_i_dzz where tfid=@tfid and deleteFlag<>'1' while @@rowcount<>0 begin set @i=@i+1 insert @t select a.tfid,a.pid,@i from tbl_i_dzz as a,@t as b where b.tfid=a.pid and b.lev=@i-1 and a.deleteFlag<>'1' end return end该怎么写呢?
returns @t table(tfid varchar(100),pid varchar(100),lev int)
在mysql中应该改成什么样呢
returns @t table(tfid varchar(100),pid varchar(100),lev int)/*定义表t用来存放取出的数据*/
begin
declare @i int/*标志递归级别*/
set @i=1
insert @t select tfid,pid,@i from tbl_i_dzz where tfid=@tfid and deleteFlag<>'1'
while @@rowcount<>0
begin
set @i=@i+1
insert @t select a.tfid,a.pid,@i from tbl_i_dzz as a,@t as b
where b.tfid=a.pid and b.lev=@i-1 and a.deleteFlag<>'1'
end
return
end该怎么写呢?