MySQL Forums
Forum List  »  MySQL for Excel

Re: Excel like formulas in MySQL
Posted by: Javier Treviño
Date: December 07, 2012 04:40PM

Hi Stefan,
Yes it can be done, if you want the value in column "B" (where the formula is being applied in Excel) also saved in the DB you can do this via an UPDATE trigger so when a new record is added to the table, the formula that is in the trigger is fired when the new record is created and the value of column B set according to the formula.

If that value in column B is just a display value then it does not need to be saved in the DB so the Table would contain just column A and you can create a View of the table that calculates the values for column B before they are displayed.

Hope this helps.

Cheers.

====================================
Javier Treviño
MySQL on Windows Team

Options: ReplyQuote


Subject
Views
Written By
Posted
2054
October 18, 2012 04:50PM
Re: Excel like formulas in MySQL
2294
December 07, 2012 04:40PM


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.