MySQL Forums
Forum List  »  Newbie

Marking Footers in a tablr
Posted by: Michael Smith
Date: October 29, 2023 10:37AM

I have a table of invoices that are identified uniquely by their Invnbr,

I would like to mark the end of each group with EXTRA1 = "X".

I have tried to use code like:

UPDATE Invoices01 GROUP by Invnbr set EXTRA1 = "X" ;

This gives me an error message.

How would I do this?


Options: ReplyQuote

Written By
Marking Footers in a tablr
October 29, 2023 10:37AM
October 30, 2023 05:53AM
November 01, 2023 05:30AM

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.