sqrt

description

Syntax

DOUBLE sqrt(DOUBLE x) Returns the square root of x.x is required to be greater than or equal to 0.

example

1. mysql> select sqrt(9);
2. +-----------+
3. | sqrt(9.0) |
4. +-----------+
5. |         3 |
6. +-----------+
7. mysql> select sqrt(2);
8. +--------------------+
9. | sqrt(2.0)          |
10. +--------------------+
11. | 1.4142135623730951 |
12. +--------------------+
13. mysql> select sqrt(100.0);
14. +-------------+
15. | sqrt(100.0) |
16. +-------------+
17. |          10 |
18. +-------------+

keywords

1. SQRT