MySQL

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

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

•

Join Date: Jul 2006

Posts: 2

Reputation: mishu007 is an unknown quantity at this point

Solved Threads: 0

mishu007

Offline

Newbie Poster

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

Jul 26th, 2006

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..........

•

Join Date: May 2006

Posts: 1,422

Reputation: stymiee is on a distinguished road

Solved Threads: 35

stymiee

Offline

He's No Good To Me Dead

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

Jul 26th, 2006

 Help with Code Tags 
 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.

John Conde
Brainyminds | Merchant Account Services | I Love Code
IT'S HERE: Merchant Accounts 101 Everything you need to know about merchant accounts!

•

Join Date: Nov 2006

Posts: 5

Reputation: hazel_0821 is an unknown quantity at this point

Solved Threads: 0

hazel_0821 hazel_0821 is offline

Offline

Newbie Poster

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

Nov 28th, 2006

•

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?

•

Join Date: Dec 2004

Posts: 440

Reputation: Sulley's Boo will become famous soon enough

Solved Threads: 10

Sulley's Boo Sulley's Boo is offline

Offline

Posting Pro in Training

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

Nov 29th, 2006

click

•

Join Date: Nov 2009

Posts: 1

Reputation: avinashzala is an unknown quantity at this point

Solved Threads: 0

avinashzala avinashzala is offline

Offline

Newbie Poster

-2

16 Days Ago

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

Last edited by peter_budo; 15 Days Ago at 4:39 am. Reason: Keep It On The Site - Posts must contain actual content and substance and cannot simply be external links.