Re: Total logged in time

2009-04-01 Thread Claudio Nanni
> 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/we

Total logged in time

2009-04-01 Thread Tom Scheper
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? -- MySQL General Mailing List For