MySQL Forums
Forum List  »  InnoDB

calculations within a single table
Posted by: mark zollo
Date: October 01, 2008 09:27AM

I have a table with a 1000 row of data. I need to execute the following calculation. I need to take the data from column 1 x column 2 x column 3 / 100 and update column 4 with the calculated data. An example would be in row 1 the data in the above columns would be calculated and updated column 4 etc. for all rows in the table.

Options: ReplyQuote

Written By
calculations within a single table
October 01, 2008 09:27AM
October 02, 2008 09:34AM

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.