w3resource
MYSQL Tutorial

MySQL SQRT() function

SQRT() function

MySQL SQRT() returns the square root of a non-negative number of the argument.

Syntax:

SQRT(X)

Where X is a number

Syntax Diagram:

MySQL SQRT() Function - Syntax Diagram

MySQL Version: 5.6


Pictorial presentation of MySQL SQRT() function

pictorial presentation of MySQL SQRT() function

Example of MySQL SQRT() function

Code:

SELECT SQRT(25);

Explanation

The above statement will return the square root of the given number 25.

Sample Output:

mysql> SELECT SQRT(25);
+----------+
| SQRT(25) |
+----------+
|        5 | 
+----------+
1 row in set (0.00 sec)

Example: SQRT() function using negative value

Code:

SELECT SQRT(-25);

Explanation

The above statement will return NULL because the value of the argument (-25) is negative.

Sample Output:

mysql> SELECT SQRT(-25);
+-----------+
| SQRT(-25) |
+-----------+
|      NULL | 
+-----------+
1 row in set (0.00 sec)

All Mathematical Functions

MySQL Mathematical Functions, slide presentation

Previous: SIN()
Next: TAN()