ing
> datediff(now(),max(tweet_createdat)) > 7);
>
> Mike
>
>
>
>
> -Original Message-
> From: John Meyer [mailto:johnme...@pueblocomputing.com]
> Sent: Sunday, November 08, 2009 9:45 AM
> To: 'Michael Dykman'
> Cc: mysql@lists.mysql.com
> Subjec
(now(),max(tweet_createdat)) > 7);
>
> Mike
>
>
>
> -Original Message-
>> From: John Meyer [mailto:johnme...@pueblocomputing.com]
>> Sent: Sunday, November 08, 2009 9:45 AM
>> To: 'Michael Dykman'
>> Cc: mysql@lists.mysql.com
>> Subj
-Original Message-
From: John Meyer [mailto:johnme...@pueblocomputing.com]
Sent: Sunday, November 08, 2009 9:45 AM
To: 'Michael Dykman'
Cc: mysql@lists.mysql.com
Subject: RE: Finding users who haven't posted in a week
Thanks, morning coffee hasn't kicked in. T
er_id having
datediff(now(),max(tweet_createdat)) > 7;
-Original Message-
From: John Meyer [mailto:johnme...@pueblocomputing.com]
Sent: Sunday, November 08, 2009 9:45 AM
To: 'Michael Dykman'
Cc: mysql@lists.mysql.com
Subject: RE: Finding users who haven't posted in a week
l Dykman [mailto:mdyk...@gmail.com]
Sent: Sunday, November 08, 2009 8:35 AM
To: John Meyer
Cc: mysql@lists.mysql.com
Subject: Re: Finding users who haven't posted in a week
the function max(), among others, makes no sense in the absence of a
GROUP BY clause.
try adding "GROUP BY user_id&q
the function max(), among others, makes no sense in the absence of a
GROUP BY clause.
try adding "GROUP BY user_id"
- michael dykman
On Sun, Nov 8, 2009 at 9:40 AM, John Meyer
wrote:
> I want to get a list of all users who haven't posted in a week. But when I
> use the following function.
>
>
I want to get a list of all users who haven't posted in a week. But when I
use the following function.
select user_id, max(tweet_createdat) from tweets where
datediff(now(),max(tweet_createdat)) > 7;
Is producing the error:
Invalid use of group function
