Hi

Does anyone have tips on the fastest way to get the last row in a table.

What I have is an int as the the primary key, using auto inc.

I currently do a select max(id), then run another query retrieving a row
based on the the max(id).

Its two queries.  

Would I be able to get it all into one?

Not using mysql 4...

Thanks.

-- 
Chris Edwards
Web Application Developer
Outer Banks Internet, Inc.
252-441-6698
[EMAIL PROTECTED]
http://www.OuterBanksInternet.com

----- Original Message ----- 
From: "Peter Brawley" <[EMAIL PROTECTED]>
To: "Bruce Feist" <[EMAIL PROTECTED]>; "MySQL List" <[EMAIL PROTECTED]>
Sent: Monday, June 09, 2003 2:13 PM
Subject: Re: array/pointer question


> >Peter Brawley wrote:
> 
> >>  MySQL, like other relational databases, does not support arrays or
> >>pointers. 
> 
> I didn't write that.
> 
> PB
> 
> 

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to