Re: Excel like formulas in MySQL

[Javier Treviño]

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