未分类
mysql 7天内用户登录统计查询
SELECT DATE(create_date) AS createdate,COUNT(*) AS total FROM sys_log WHERE DATE_SUB(CURDATE(),INTERVAL 7 DAY) < DATE(create_date) AND log_type=0 AND method like '%Login%'&
阅读全文