表设计
ID userno ip
同一IP多用户
根据IP分组 统计不同用户的个数。
只需group by ip ;count(distinct userno)即可
用户不经常在一个IP (分组 取每组的前十条)
SET @codeum := '';
SET @csum := 0;
SELECT * from
(
SELECT si_a.*,
IF (si_a.lolo_userno = @codeum, (@csum := 1 + @csum), @csum := 0 ) AS icount ,
@codeum := si_a.lolo_userno as codes
FROM t_loginlog si_a ORDER BY si_a.lolo_userno,lolo_stime DESC
)
si_b where si_b.icount < 10