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 ;