MySQL Forums
Forum List  »  Newbie

Re: Getting data from previous row
Posted by: Peter Brawley
Date: September 20, 2011 10:04AM

> What I would like to achieve is to get the invoice_dt from the invoice that was prior to the row I am on.

What defines "the row I am on"?

To get the most recently inserted auto_increment value in the current thread, invoke last_insert_id().

Options: ReplyQuote


Subject
Written By
Posted
September 20, 2011 09:35AM
Re: Getting data from previous row
September 20, 2011 10:04AM
September 22, 2011 07:05PM
September 23, 2011 06:29AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.