Last values in mysql

Expand Post »

I have a databse in mysql and am looking to select the last 5 values in the database and there contence. How would i do this.

Will be using php to do this.

Thanks

There is an incramenting variable called Id and could use that if possible.

Similar Threads

insert values to mysql database in JSP
Why does it insert NULL values into MySQL DB??? in ASP.NET
Help with 301 redirect code - jsp in url in JSP
dynamically generated textboxes & radio buttons php, insert into db in PHP
FULLTEXT searching in MySQL

namit

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

44 posts
since Jun 2005

Permalink

Nov 29th, 2005

Re: Last values in mysql

I think this will work. I'm not positive if TOP is in MySQL.

SELECT TOP 5 *
FROM table
ORDER BY id DESC

(assuming 'id' is the primary key in the table)

Phaelax

Reputation Points: 92

Solved Threads: 51

Practically a Posting Shark

Offline

856 posts
since Mar 2004

Permalink

Dec 26th, 2005

Re: Last values in mysql

you might also want to put LIMIT 5 on there at the very end to just retrieve the last 5 results

paradox814

Reputation Points: 13

Solved Threads: 4

Posting Whiz

Offline

351 posts
since Oct 2004

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MySQL Forum Timeline: index checking?

Next Thread in MySQL Forum Timeline: MySql database Synchronization

DaniWeb Message

Cancel Changes

User Name
Password