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]