mysql 限流 查询

select * from order where pid=1017 and addtime BETWEEN CONCAT( DATE_FORMAT(NOW(),'%Y-%m-%d'),' 00:00:00') AND
CONCAT( DATE_FORMAT(NOW(),'%Y-%m-%d'),' 23:59:59') group by ip having count(ip)>=10

 

posted @ 2020-09-16 20:39  applekingghfhfhbr  阅读(342)  评论(0编辑  收藏  举报