上个月查询的 MySQL 不同活跃用户

Question

好吧，我已经尝试了很多，这看起来很适合我，但它绝对不适合:

SELECT COUNT( DISTINCT 'uid' ) AS `Records` , DATE( FROM_UNIXTIME( `epoch_timestamp` ) ) AS `Date`
FROM `log`
GROUP BY DATE( FROM_UNIXTIME( `epoch_timestamp` ) )
LIMIT 0 , 30

出于这个原因，它会在每个日期旁边返回一个 1。如果我取出不同的值，它似乎会给出当天计数的总记录。

Answer 1

似乎您的sql不正确，请尝试将'uid'周围的单引号替换为`。

SELECT COUNT( DISTINCT `uid` ) AS `Records` , DATE( FROM_UNIXTIME( `epoch_timestamp` ) ) AS `Date`
FROM `log`
GROUP BY DATE( FROM_UNIXTIME( `epoch_timestamp` ) )
LIMIT 0 , 30