我有一个mysql表,如下所示:当访问者访问网站时,它将访问者id和页面id存储为一行。SELECT COUNT(visid),visid FROM vislog GROUP BY visid ORDER BY COUNT(visid) DESC
但我不知道下一步该怎么计算可以像MySQL查询一样做吗?
我目前的想法是将每个数字与添加的3-8进行比较,并分别增加计数数组。我主要缺乏理解的是如何增加数组的特定索引。push ebpmov esi, [ebp + 16] ; @ holds array to store count of integer occurances je inc_3 ; current thought is it cmp to each num 3-loop fill
这是我的问题 WHERE (date >= '2012-06-26'AND date < '2012-06-30') AND (Avail > '0')SELECT COUNT(*) as total, toys, date FROM T2
WHERE (date >= '2012-06-26'AND>= '2012-06-26