MySQL Forums
Forum List  »  Newbie

Re: Get Value of a TOP Row
Posted by: Michael Smith
Date: July 07, 2023 07:47AM

Barry:

Its OK, I found away around this.

update Invoices01 set EXTRA4 = "XX";
UPDATE Invoices01 SET EXTRA4 = "YY" Limit 1;

With this code I can use the "where" clause to get the value in the particular field in the Top row.

So I am out of the woods.

Thank you for your interest.

Mike

Options: ReplyQuote


Subject
Written By
Posted
July 06, 2023 07:12PM
Re: Get Value of a TOP Row
July 07, 2023 07:47AM


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.