Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query
optimization, and usability that you won’t want to miss.
Returns the given number exponentiated to the given power.
POW ( number, power )
POWER ( number, power )
Float or double. If either argument is null, returns NULL
.
SELECT POW(2, 8);
+-----------+
| POW(2, 8) |
+-----------+
| 256 |
+-----------+
SELECT POW(2, 16);
+------------+
| POW(2, 16) |
+------------+
| 65536 |
+------------+
SELECT POW(2, 24);
+------------+
| POW(2, 24) |
+------------+
| 16777216 |
+------------+
SELECT POW(2, 2.5);
+-------------------+
| POW(2, 2.5) |
+-------------------+
| 5.656854249492381 |
+-------------------+