SQRT(X) returns the square root of a non-negative number X. : SQRT « Math Numeric Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. Math Numeric Functions
  3. SQRT
mysql>
mysql> SELECT SQRT(4);
+---------+
| SQRT(4) |
+---------+
|       2 |
+---------+
1 row in set (0.00 sec)

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

mysql>








21.34.SQRT
21.34.1.SQRT(X) returns the square root of a non-negative number X.
21.34.2.SQRT(-16);