本文介绍了移动平均线-MySQL的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在尝试实施系统范围的登录限制,我需要计算最近3个月内每天失败登录尝试的平均次数.
I'm trying to implement system-wide login throttling and I need to calculate the daily average number of failed login attempts from the last 3 months.
我当前在每次登录失败时都插入一条记录,每条记录都带有时间戳.如何在MySQL中做到这一点?
I'm currently inserting a record on every login fail, each with a timestamp. How can I do this in MySQL?
预先感谢您的帮助
推荐答案SELECT AVG(cnt) FROM (SELECT COUNT(*) AS cnt FROM mytable WHERE `date` BETWEEN DATE_SUB(NOW(), INTERVAL 3 MONTH) AND NOW() GROUP BY DATE(`date`)) x
假设您有一个表mytable,其中表date的类型为date,datetime或timestamp
Assuming you have a table mytable with field date of type date, datetime or timestamp
更多推荐
移动平均线
发布评论