How to find last row in mysql table?

Asked Jan 02 '16 at 15:20

Active Jan 02 '16 at 15:24

Viewed 32 times

I've a table something as follows

id                                         other_columns
1
1
1
2
2
3
1
3

How do I detect that row no. 7 is the last row with id value 1. Similarly row number 5 is the last row with id value 2. Row number 8 is last row with id value 3. Is it possible to achieve this using php?

edited Jan 02 '16 at 15:24

asked Jan 02 '16 at 15:20

van

1

order is relative, there must be some field with value 7 for this to make sense – amdixon Jan 02 '16 at 15:23
3

You cannot. Rows in SQL represent unordered sets. – Strawberry Jan 02 '16 at 15:23
Do you have some other column that you can use to order them, like a date? – Barmar Jan 02 '16 at 15:23
Yes a column date exists. – van Jan 02 '16 at 15:25
Amend your question accordingly. – Strawberry Jan 02 '16 at 15:25
See the linked question. Find the row with the maximum date grouped by ID. – Barmar Jan 02 '16 at 15:27

How to find last row in mysql table?

0 Answers0