移动平均线

本文介绍了移动平均线-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