MySQL Forums
Forum List  »  Newbie

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


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.


Options: ReplyQuote

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

Sorry, only registered users may post in this forum.

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.