Changes

MySQL Mathematical Functions

62 bytes added, 19:25, 19 May 2009
no edit summary
<google>BUY_MYSQL</google>  MySQL provides a a number of functions used for performing algebraic, geometric and trigonometric calculations on database data. In this chapter the basics of using this these functions will be covered.
== MySQL Arithmetic Functions ==
</table>
As with most MySQL functions it is easy to experimenbt experiment with them without having to access data in a table simply using the SELECT statement. For example, to see the PI() function in action:
<pre>
== Summary ==
Given the scientific nature of many of the numeric functions provided with MySQL it is unlikely that many of them get used very much. That said, it is reassuring to know that the capabilities are there if you ever need them.
Now that we have looked at text and number manipulation functions we will now move on to look at [[Working with Dates and Times in MySQL|working with dates and times in MySQL]].
<google>BUY_MYSQL_BOTTOM</google>
<hr>