riginal Message-
> From: Martin Jespersen [mailto:[EMAIL PROTECTED]
> Sent: Friday, August 04, 2006 5:35 PM
> To: Daevid Vincent
> Cc: mysql@lists.mysql.com
> Subject: Re: FW: How do I find all the users that are new
> since my last login (repost)
>
> You could add an e
You could add an extra field called last_login_date which you'd set only
once per session - at login time. At login time you'd set this to the
value that exists in login_date. Then use that for comparison against
created_on.
Daevid Vincent wrote:
I have a SQL challenge I'm not sure how to sol
I have a SQL challenge I'm not sure how to solve. But it's so common, I feel
kind of stupid asking this...
I have a 'user' table with 'login_date' which is an auto updated DATETIME
column and a 'created_on' which is a DATETIME (but not updated after the
record is created the first time)
I want to
