| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Tom Scheper | Date: | April 1 2009 2:14pm |
| Subject: | Total logged in time | ||
| View as plain text | |||
Hi,
I have a table like so
id autoinc
userid int
action enum ('login', 'logout' )
timestamp
--
Is it possible to perform a mysql query that gets the total logged in
time for any one user on any one particular day/week/month? And how?
| Thread | ||
|---|---|---|
| • Total logged in time | Tom Scheper | 1 Apr |
| • Re: Total logged in time | Claudio Nanni | 1 Apr |