set @v_begindt=0;
select a.Fromtime into @v_begindt from
(SELECT a.Fromtime FROM heidunlog.dbaudit_index a WHERE a.Fromtime >
( SELECT ifnull(t.overdt,unix_timestamp(date(from_unixtime(t.dt-86400))))
FROM heidunlog.abnormalreporttask t WHERE id = 5
)
and
a.Fromtime< (select a.Fromtime from heidunlog.dbaudit_index a
where a.noncekey=1 order by a.Fromtime desc limit 1
) and a.noncekey <> -1 o
rder BY a.tablename ASC limit 1
) a;
select @v_begindt;这个语句在存储过程中执行,第一次可以正常取到@v_begindt的值,第二次,或者第三次执行的时候,@v_begindt 就取不到值了,说明下:肯定有值的。是不是使用的不正常还是什么,急
select a.Fromtime into @v_begindt from
(SELECT a.Fromtime FROM heidunlog.dbaudit_index a WHERE a.Fromtime >
( SELECT ifnull(t.overdt,unix_timestamp(date(from_unixtime(t.dt-86400))))
FROM heidunlog.abnormalreporttask t WHERE id = 5
)
and
a.Fromtime< (select a.Fromtime from heidunlog.dbaudit_index a
where a.noncekey=1 order by a.Fromtime desc limit 1
) and a.noncekey <> -1 o
rder BY a.tablename ASC limit 1
) a;
select @v_begindt;这个语句在存储过程中执行,第一次可以正常取到@v_begindt的值,第二次,或者第三次执行的时候,@v_begindt 就取不到值了,说明下:肯定有值的。是不是使用的不正常还是什么,急
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货