mysql 定时排除 用户 非正常 out

来源:互联网 发布:axure iphone组件 mac 编辑:程序博客网 时间:2024/03/29 20:01

http://blog.csdn.net/mer1234567/article/details/7514855

http://blog.csdn.net/zlp5201/article/details/38309095

-------------------------

set GLOBAL event_scheduler = 1;

use radius;
drop EVENT if EXISTS cron_check_radacct;


# 设置分隔符为 '$$' ,mysql默认的语句分隔符为 ';' ,这样在后续的 create 到 end 这段代码都会看成是一条语句来执行  
DELIMITER $$  
create event cron_check_radacct   
on schedule every 5 MINUTE starts timestamp '2017-11-17 15:18:00'  
do  
begin  
UPDATE radacct SET acctstoptime =  FROM_UNIXTIME(UNIX_TIMESTAMP(acctstarttime) + acctsessiontime,'%Y-%m-%d %H:%i:%s')
 where acctstoptime IS NULL AND ((UNIX_TIMESTAMP(cast(acctstarttime as signed)) +cast(acctsessiontime as signed) +120) - UNIX_TIMESTAMP()) <0;
end $$  
  
 
DELIMITER ;
原创粉丝点击