In MySQL, how to raise a number to the power of another number?

POWER() function is used to raise a number to the power of another number. POW() is the synonym of POWER() function. In these functions, the first arguments work as the base and the second argument works as the exponent. 

Syntax

POWER(M, N)  

Here, 

• M is the number which is the base of exponentiation. 
• N is the number which is the exponent of exponentiation.

Example

mysql> Select POWER(2,3),POW(2,3);
+------------+----------+
| POWER(2,3) | POW(2,3) |
+------------+----------+
|          8 |        8 |
+------------+----------+
1 row in set (0.00 sec)

Govinda Sai

Published on 20-Feb-2018 18:03:51

• Related Questions & Answers
• To return value of a number raised to the power of another number, we should use ^ operator in MySQL?
• Raise elements of tuple as power to another tuple in Python
• Check if a number is a power of another number in C++
• Calculating power of a number in MySQL?
• How to create a column of raise to the power of another column in data frames stored in R list?
• PHP – How to raise an arbitrary precision number to another using bcpow() function?
• How to find power of a number in Python?
• How to get the exponent power of a number in JavaScript?
• Java program to calculate the power of a number
• How to Find the Power of a Number Using Recursion in Python?
• How to find the fractional power of a negative number in R?
• C++ Program to Calculate Power of a Number
• How to find the raise to the power of all values in an R vector?
• How to calculate Power of a number using recursion in C#?
• Raise x to the power n using Recursion in Java