Dykman'
Cc: mysql@lists.mysql.com
Subject: RE: Finding users who haven't posted in a week
Thanks, morning coffee hasn't kicked in. This worked out well.
select user_id, max(tweet_createdat) from tweets group by user_id having
datediff(now(),max(tweet_createdat)) 7;
I forgot when to use
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. This worked out well.
select user_id, max(tweet_createdat) from
-
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. This worked out well.
select user_id, max
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
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
johnme...@pueblocomputing.com wrote:
I want to get a list of all users who haven't posted in a week. But when I
use
[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
- michael dykman
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
Thanks, morning coffee