Hi, I would need simply select the last entered row specified by condition,e.g:
SELECT ID from bugs WHERE user=Me
I need to return only the very last ID entered by user 'Me'. Is there any simple way? Thank you
views:
63answers:
3
+3
A:
It would be best to have a TIMESTAMP column that defaults to CURRENT_TIMESTAMP .. it is the only true predictive behavior you can find here.
The second-best thing you can do is ORDER BY ID DESC LIMIT 1 and hope the newest ID is the largest value.
Matt
2010-05-05 04:25:54
+1 Matt. Useful pointers.
macek
2010-05-05 05:17:49
A:
In concurrency, the latest record may not be the record you just entered. It may better to get the latest record using the primary key.
If it is a auto increment field, use SELECT LAST_INSERT_ID(); to get the id you just created.
Wayne
2010-05-05 04:59:01
This **only** works if you do not perform inserting after the row you're trying to query. E.g., if someone registers (`insert into users ...`) then creates a post (`insert into posts ...`), `last_insert_id()` will refer to the last `posts.id`. At this point, there is no way to select the last user using `last_insert_id()`.
macek
2010-05-05 05:17:02