Ad:

MySQL Discussion Thread
Unsolved
Views: 121071

Jul 26th, 2006

How to select the Last row from a table..using Mysql

Expand Post »

Suppose this is a Table

Create Table Person(
PersonID varchar(8),
PersonLN varchar(16),
PersonFN varchar(16),
PersonADD varchar(64),
PersonPH varchar(16));

so there are many enrty in that table.. So how to select the lastest row entry from that table? what will be the Mysql statement?

take PersonID as a Primary key..........

Similar Threads

How to change the color of selected row of an HTML table without using CSS or Javascr in VB.NET
Apache in Linux Servers and Apache
can i select the 2nd row/record from a table in MySQL
php table help in PHP
mysql errors, from submit.php and index.php in PHP

mishu007

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Jul 2006

Permalink

Jul 26th, 2006

Re: How to select the Last row from a table..using Mysql

MySQL Syntax (Toggle Plain Text)
SELECT *
FROM Person
ORDER BY PersonID DESC
LIMIT 1
SELECT *
FROM Person
ORDER BY PersonID DESC
LIMIT 1

Last edited by stymiee; Jul 26th, 2006 at 11:10 am.

stymiee

Moderator

Reputation Points: 161

Solved Threads: 38

He's No Good To Me Dead

Offline

1,422 posts
since May 2006

Permalink

Nov 28th, 2006

Re: How to select the Last row from a table..using Mysql

Click to Expand / Collapse Quote originally posted by mishu007 ...

Suppose this is a Table

Create Table Person(
PersonID varchar(8),
PersonLN varchar(16),
PersonFN varchar(16),
PersonADD varchar(64),
PersonPH varchar(16));

so there are many enrty in that table.. So how to select the lastest row entry from that table? what will be the Mysql statement?

take PersonID as a Primary key..........

do you have the values?

hazel_0821

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

5 posts
since Nov 2006

Permalink

Nov 29th, 2006

Re: How to select the Last row from a table..using Mysql

click

Sulley's Boo

Reputation Points: 529

Solved Threads: 10

Posting Pro in Training

Offline

450 posts
since Dec 2004

Permalink

Nov 7th, 2009

-2

Re: How to select the Last row from a table..using Mysql

Just check out this for getting last updated row
<URL SNIPPED>

Last edited by peter_budo; Nov 8th, 2009 at 4:39 am. Reason: Keep It On The Site - Posts must contain actual content and substance and cannot simply be external links.

avinashzala

Reputation Points: 9

Solved Threads: 1

Newbie Poster

Offline

4 posts
since Nov 2009

Permalink

Jan 25th, 2011

Re: How to select the Last row from a table..using Mysql

You can use maxdb_insert_id() For the
Getting last record from table..

Ashish Patel

Last edited by Ezzaral; Jan 26th, 2011 at 4:09 pm. Reason: Snipped "fake sig" link. Please restrict such links to your site-wide user signature, which can be edited from the user control panel.

technoempire

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

4 posts
since Jan 2011

Permalink

Jan 25th, 2011

Re: How to select the Last row from a table..using Mysql

SELECT * FROM Person ORDER BY PersonID DESC LIMIT 1

Ashish Patel

Last edited by Ezzaral; Jan 26th, 2011 at 4:10 pm. Reason: Snipped "fake sig" link. Please restrict such links to your site-wide user signature, which can be edited from the user control panel.

technoempire

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

4 posts
since Jan 2011

Permalink

Jan 25th, 2011

Re: How to select the Last row from a table..using Mysql

sorry but without an auto-incrementing numerical id, it doesn't look as if sorting will work. It looks like the primary key is PersonID varchar(8),

so id 9a would be rated as a bigger id than id 88888a wouldn't it? That's how it goes with varchar, it's an alphabetical sort, not a numerical one.

How are these varchar ids assigned?? Can they be changed to be auto-incrementing numerical?

And of course this antique thread has been revived by a signature spammer, and the posts should be deleted.

drjohn

Reputation Points: 76

Solved Threads: 78

Posting Pro in Training

Offline

423 posts
since Mar 2010

Permalink

Nov 17th, 2011

Re: How to select the Last row from a table..using Mysql

hi guys use the following options

SELECT * FROM `myfield` WHERE `trackid` = '65' ORDER BY `id` DESC LIMIT 0,1

if u doesn't need a 'where' check use the following query

SELECT * FROM `myfield` ORDER BY `id` DESC LIMIT 0,1

charles_7

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Nov 2011

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: Retrieve data based on date

Next Thread in MySQL Forum Timeline: Relating Master database and child database

DaniWeb Message

Cancel Changes

User Name
Password