MySQL

displying last 10 recods from table

Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: Oct 2007

Posts: 45

Reputation: rohitrohitrohit is an unknown quantity at this point

Solved Threads: 3

rohitrohitrohit rohitrohitrohit is offline

Offline

Light Poster

displying last 10 recods from table

Nov 7th, 2008

hi all,
how to display last 10 record form a table.please help me.

•

Join Date: Jul 2006

Posts: 869

Reputation: pritaeas will become famous soon enough

Solved Threads: 140

pritaeas

Offline

Practically a Posting Shark

Re: displying last 10 recods from table

Nov 7th, 2008

Do you have a timestamp column ? Then sort descending and limit 10 on that column.

"If it is NOT source, it is NOT software."
-- NASA

•

Join Date: Aug 2008

Posts: 1,162

Reputation: dickersonka will become famous soon enough

Solved Threads: 137

dickersonka dickersonka is offline

Offline

Veteran Poster

Re: displying last 10 recods from table

Nov 7th, 2008

either go with a timestamp or id column, assuming its an integer or bigint

 Help with Code Tags 
 MySQL Syntax (Toggle Plain Text) 
SELECT * FROM table ORDER BY idcolumn desc LIMIT 10
 
SELECT * FROM table ORDER BY timestampcolumn desc LIMIT 10
select * from table order by idcolumn desc limit 10

select * from table order by timestampcolumn desc limit 10