I have a table that records connections from customers to our server.
When there is a software problem with our customer's that have older
versions of our software, it will dial our server constantly over and
over again.=20
I want to be able to detect this by having a query that does something
like this.. (I know this where clause won't really work)
Select count(cust.id)
from cust
where cust.time > UNIX_TIMESTAMP(DATE_SUB(NOW(),interval 1 HOUR)) &&
count(cust.id) > 5
Group by cust.id;
Is there a way to do this with one query?
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw