MySQL Forums
Forum List  »  Newbie

How do I mark a record
Posted by: Michael Smith
Date: February 22, 2023 12:01PM

I am trying to mark a particular record with extra1 = "xxxxx" at the current row position.
I have declared a local variable as mcompnbr (company number) to get the company number and use that in the set command as below. Unfortunately this generates errors and won't run.

DECLARE mcompnbr INT(11);
update company
set mcompmbr := compnbr;
set extra1 = "xxxxx" where compnbr = mcompnbr;

How should I do this?

Options: ReplyQuote

Written By
How do I mark a record
February 22, 2023 12:01PM

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.