No data - zero rows fetched错误提示

[lienzhu]

存储过程中，加入这句语句
select lastupdate into s_lastupdate from pre_common_failedlogin where username='myname';
就提示
0 row(s) affected, 1 warning(s): 1329 No data - zero rows fetched, selected, or processed
前后没有用游标

[yashifc]

select max(lastupdate) into s_lastupdate from pre_common_failedlogin where username='myname'; 加个函数应该就不会有警告了

[wwwwb]

代码是什么，贴出来

[lienzhu]

CREATE DEFINER=`root`@`%` PROCEDURE `test`( in P_UserName char(15), out s_lastupdate int ) BEGIN select lastupdate into s_lastupdate from pre_common_failedlogin where username=P_UserName; if s_lastupdate is null then set s_lastupdate=0; end if; END

[wwwwb]

select lastupdate into s_lastupdate from pre_common_failedlogin where username=P_UserName; 在命令行下运行，提示什么

[ACMAIN_CHM]

很正常，应该是没有符合条件的记录。

[知道就是你]

使用 select into 变量，如果变量为空时，引发一些不必要的问题，导致循环终断，要避免这个问题，只需在使用变量前判断变量值是否为空，如果不为空 在执行其他操作即可，完善后脚本如下：

CREATE DEFINER=`root`@`%` PROCEDURE `test`(
in P_UserName char(15),
out s_lastupdate int
)
BEGIN
select count(*) into @isnext from pre_common_failedlogin where username=P_UserName;
if(@isnext>0)  then 
select lastupdate into s_lastupdate from pre_common_failedlogin where username=P_UserName;
if s_lastupdate is null then
set s_lastupdate=0;
end if;

end if ;
END