POWER()

Description

POWER(X, Y) returns the value of X raised to the power of Y.

Syntax

1. > POWER(X, Y)

Arguments

Examples

1. drop table if exists t1;
2. create table t1(a int,b int);
3. insert into t1 values(5,-2),(10,3),(100,0),(4,3),(6,-3);

5. mysql> select power(a,b) from t1;
6. +----------------------+
7. | power(a, b)          |
8. +----------------------+
9. |                 0.04 |
10. |                 1000 |
11. |                    1 |
12. |                   64 |
13. | 0.004629629629629629 |
14. +----------------------+
15. 5 rows in set (0.01 sec)

17. mysql> select power(a,2) as a1, power(b,2) as b1 from t1 where power(a,2) > power(b,2) order by a1 asc;
18. +-------+------+
19. | a1    | b1   |
20. +-------+------+
21. |    16 |    9 |
22. |    25 |    4 |
23. |    36 |    9 |
24. |   100 |    9 |
25. | 10000 |    0 |
26. +-------+------+
27. 5 rows in set (0.01 sec)