MySQL in a Nutshell, 2nd Edition

Name

PI()

Synopsis

PI()

This function returns by default the first five decimal places of the number pi. You can adjust it to include more decimal places by adding a mask to the end of the function. There is no argument within the parentheses of the function. Here is an example:

SELECT PI( ), PI( ) + 0.0000000000;

+----------+----------------------+
| PI( )    | PI( ) + 0.0000000000 |
+----------+----------------------+
| 3.141593 |         3.1415926536 |
+----------+----------------------+