Mailing List
Home
MySQL General - General MySQL discussion
MaxDB - Everything about MaxDB, formerly known as SAP DB
MySQL on Win32 - Runing MySQL on Windows 9x/Me/NT/2000/XP
Java Help - Mostly related to the MySQL Connector/J driver
ODBC - ODBC with the MySQL Connector/ODBC driver
Perl - Perl support for MySQL with DBI and DBD::mysql
MySQL++ - Programming with the C++ API to MySQL
Subjects
• mysql openssl Question
• mysql:it 's a db not a dbms how it 's possible?!
• Does the binary log enabling affect the MySQL performances?
• Strange behavior, Table Level Permission
• FULLTEXT query format question
• Preventing Duplicate Entries
• Comparing and writing out BLOBS
• Executing MySQL Commands From Within C Program
• Can 't access mysql after kernel upgrade
• Mysql 4 0 Oracle Stored Procedure Trigger Conversion
• Downgrade Mysql from 4 to 3 23
• MySQL Cluster Software
• mysql test 4 1 fails with the gis test
• ERROR 2002: Can 't connect to local MySQL server through socket
• Getting Identity after INSERT
• Update one field with more fields from another table
• ERROR 1045: Access denied for user: 'root@localhost ' (Using
password: NO)
• mysql have same function mthod as Oracle decode()
 
Search:  
Power your search with and, or, +, -, or "some phrase" operators.
AW: retrieving last record for all distinct users

AW: retrieving last record for all distinct users

2004-03-20       - By B. Fongo

 Back
If I 've understood you what I want, then MySQL time functions can help.
It is always possible to substract time with MySQL. So if you substract
the value of your column "TIMESTAMP " from current time, you will get all
records that are older than now. I can 't try it now, but I believe
something in this direction could help you:

SELECT distinct LOGIN, TIMESTAMP, IP from SESSIONS WHERE
CURRENT_TIMESTAMP - TIMESTAMP = 0 || > 0


Note that, I did not try it.

HTH

Babs



-- --Ursprüngliche Nachricht-- --
Von: motorpsychkill [mailto:x@(protected)]
Gesendet: Samstag, 20. März 2004 02:18
An: mysql
Betreff: retrieving last record for all distinct users

I have a table SESSIONS with the following fields:

SESSION_ID      LOGIN      IP      TIMESTAMP

I am trying to select the last login record for all distinct users. The
closest
I can get to is:

select distinct LOGIN, TIMESTAMP, IP from SESSIONS group by LOGIN order
by
TIMESTAMP desc

This kind of works but it does not get the correct IP for the last
TIMESTAMP. This seems easy enough, but I can 't seem to figure this one
out
today. Can anybody see what I 'm missing? Thanks!

-m


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=mysql @(protected)



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=mysql @(protected)