MySQL PI() Function

 In MySQL, the PI() function returns the mathematical constant π (pi), which is approximately 3.14159. This function does not require any arguments and is often used in calculations that involve circles, angles, or trigonometric operations.

Syntax:

PI()

Example Usage:

SELECT PI();

This will return:

3.14159265358979

You can use this value in further mathematical expressions, for example:

SELECT PI() * 2 AS circumference_of_unit_circle;

This calculates the circumference of a circle with a radius of 1:

6.28318530717959

The PI() function is particularly useful in cases where you need a precise value for π in your SQL calculations.