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?

Mike

Options: ReplyQuote


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


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.