6 messages in com.mysql.lists.win32RE: get the last row
FromSent OnAttachments
Christian Bacher20 Mar 2002 11:02 
Rob Spijkerman20 Mar 2002 13:27 
Christian Bacher20 Mar 2002 14:35 
Christian Bacher20 Mar 2002 14:37 
tjaybelt20 Mar 2002 22:09 
Aaron West21 Mar 2002 08:55 
Subject:RE: get the last row
From:Christian Bacher (cp@datacomm.ch)
Date:03/20/2002 02:35:35 PM
List:com.mysql.lists.win32

the last row of a particular row!

At 14:29 20.03.2002 -0800, you wrote:

This is a complex question... Are you trying to get the last row inserted or the last row of a particular index?

to get the primarykey of the last inserted record of a auto_increment field, try this: SELECT LAST_INSERT_ID FROM tablename

-----Original Message----- From: Christian Bacher [mailto:cp@datacomm.ch] Sent: Wednesday, March 20, 2002 11:03 AM To: win@lists.mysql.com Subject: get the last row

hello, it seems, that this question is kind of trivial, but How do I get the last entry of a column (and only the last one) in a query. Is there a special synthax? Thx for any help. chris.

--------------------------------------------------------------------- Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before posting. To request this thread, e-mail win3@lists.mysql.com

To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail win3@lists.mysql.com instead.