MySQL PI() Function
The MySQL PI() function returns the value of 𝜋 (pi) displayed with 6 decimal places.
Note: This function displays the value of 𝜋 with only 6 decimal places. However, internally it uses the double-precision value when used in calculations with other double-precision values.
Syntax
PI()
Parameters
No parameter is required.
Return Value
Returns the value of 𝜋.
Example 1:
The example below shows the usage of PI() function.
mysql> SELECT PI(); Result: 3.141593 mysql> SELECT PI() * 1; Result: 3.141593 mysql> SELECT PI() * 1.00; Result: 3.141593 mysql> SELECT PI() * 1.00000000000000; Result: 3.14159265358979
Example 2:
Consider a database table called Sample with the following records:
Data | Radius |
---|---|
Data 1 | 1 |
Data 2 | 2 |
Data 3 | 3 |
Data 4 | 4 |
Data 5 | 5 |
The statement given below can be used to calculate the area of the circle where radius is specified by values of column Radius.
SELECT *, (PI() * Radius * Radius) AS Area FROM Sample;
This will produce the result as shown below:
Data | Radius | Area |
---|---|---|
Data 1 | 1 | 3.141593 |
Data 2 | 2 | 12.566371 |
Data 3 | 3 | 28.274334 |
Data 4 | 4 | 50.265482 |
Data 5 | 5 | 78.539816 |
❮ MySQL Functions