Fetching last 5 Records

Hello All

I have a mysql table and I want to fetch last inserted five records from the table. Can anyone tell me how can I do this using query?

 

Generally you would use:

SELECT column_names FROM my_table ORDER BY id_column DESC LIMIT 5;

 

You need to count the number of rows, then LIMIT $count, 5

 

Sorry I forgot to add subtract 5 from count. So $count = $count -5;

 

SELECT column_names FROM my_table ORDER BY id_column LIMIT COUNT(id_column) - 5, 5

Code (markup):

Something like that should do it

 

provided you have an integer id column that increments with every insertion

otherwise tag each row with a date and sort on that

 

COUNT works regardless of the id being an integer, varchar or otherwise

 

ordering however doesnt, especially if the column doesnt exist

all the solutions above assume the existance of this column

 

If there is no ID column or a date column there would be no way to do any date based or logical ordering at all. In most situations it would be irrational to design a database table without some chronological identifier.

 

exactly

in my experience, making assumptions about 'most situations' leads to problems

 

"I want to fetch last inserted five records"

I don't know about you guys, but that infers a need for a "chronological identifier" to me.