Programming Forums > Web Development and Design > Other Web Development Languages

kruptof · Jun 28th, 2007, 2:47 PM

Does anybody know whether it is possible to get the last 10 records in a table, without having to load the whole contents of the table? If that's not possible then what other way would you recommend.

Infinite Recursion · Jun 28th, 2007, 3:01 PM

If it has some sort of sequential id or date associated with the record, you could do this:

SELECT * FROM mytable ORDER BY seq_id DESC LIMIT 10;

Basically, this puts the last entries on top (via sorting in descending order), then limiting the results to 10 via LIMIT.

kruptof · Jun 28th, 2007, 4:29 PM

Thanks a bunch IR that was exactly what I was looking for.

Infinite Recursion · Jun 29th, 2007, 9:23 AM

Glad you got it worked out man.

Jun 28th, 2007, 3:01 PM	#2
Infinite Recursion Programming Guru Join Date: Jul 2004 Location: United States Posts: 3,436 Rep Power: 7	If it has some sort of sequential id or date associated with the record, you could do this: SELECT * FROM mytable ORDER BY seq_id DESC LIMIT 10; Basically, this puts the last entries on top (via sorting in descending order), then limiting the results to 10 via LIMIT. __________________ http://jasonpowers.net "There are a thousand hacking at the branches of evil to one who is striking at the root."

Jun 29th, 2007, 9:23 AM	#4
Infinite Recursion Programming Guru Join Date: Jul 2004 Location: United States Posts: 3,436 Rep Power: 7	Glad you got it worked out man. __________________ http://jasonpowers.net "There are a thousand hacking at the branches of evil to one who is striking at the root."

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
MySQL & Python	snipertomcat	Python	2	May 9th, 2007 12:49 PM
MySql Error	paulchwd	Other Web Development Languages	8	Feb 27th, 2007 1:37 PM
mysql table view require()or suggestions.	piercy	PHP	15	Apr 28th, 2006 6:29 AM
Tutorial - Using MySQL in C#	Darkhack	C#	12	Jan 17th, 2006 9:28 AM
Simple Perl / MySQL Problem.. pls help!	domquemo	Perl	0	Jan 11th, 2006 4:08 AM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Programming Forums > Web Development and Design > Other Web Development Languages

mysql get last 10 records in a table