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?
Mike

Options: ReplyQuote


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


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.