sqrt

description

Syntax

DOUBLE sqrt(DOUBLE x) 返回x的平方根,要求x大于或等于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