这里写代码片
$sql = "SELECT concat( date_format( FROM_UNIXTIME(record_time), '%H:' ) , floor( date_format( FROM_UNIXTIME(record_time), '%i' )/ 3) * 3 ) AS c, SUM(player_role_num) AS n
FROM fa_service_message
WHERE service_id = $service_id and platform_id = $platform_id and channel_id = $channel_id and record_time BETWEEN $nows and $nextDay
GROUP BY c
ORDER BY id ASC";
//record_time 为table 的column
查询数据库 统计每3分钟的在线人数
最新推荐文章于 2024-01-16 10:22:43 发布