payment fuction

[jcuellar]

Hello Everyone,

I'm new to mysql and was trying to build a amortization table. I was wondering if there where any functions in my sql that are similiar to the payment function in excel. Thanks in advance.

 

[TonyGroves]

No, MySQL provides no financial functions.

 

[jcuellar]

Thanks for your response Tony you have saved me lots of time.

Is there any database program that anyone knows of that does have financial functions or is using a spreadsheet my only option?

 

[TonyGroves]

You could find out the formula involved, and include that in your database query.

 

[johnwm]

In general you shuld use your database server (backend) for storing data. Use your front end for display of data. Do your calculations in your business layer (if it's a 3-tier system) otherwise do calculations in the frontend.

Which frontend are you using - that will determine which forum to go to, and what questions to ask.

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller