MySQL Forums
Forum List  »  Newbie

updating table with calculated results
Posted by: Harland Oracle
Date: April 26, 2023 10:50AM

I have a batting2022 table that has an int field called "fldpct". This table also has playerID and yearID.

I have a Fielding table that has all the fielding stats in it by playerID, and yearID
the fields are: Assists (a), Putouts (po) and Errors (e)
this will return a decimal number. round up the decimal number to a 3-digit integer (x1000). If this number is >=999 then fldpct=999

write the fldpct to the batting table.

thanks in advance

Options: ReplyQuote

Written By
updating table with calculated results
April 26, 2023 10:50AM

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.