MySQL POW() Function

 The POW() function in MySQL is used to raise a number to the power of another number. It's shorthand for POWER(), and both functions work the same way.

Syntax:

POW(base, exponent)

• base: The base number that you want to raise.
• exponent: The power to which the base number is raised.

Example:

1. Basic example:

   SELECT POW(2, 3);
   

   This will return 8 because 2 raised to the power of 3 is 8.

2. Using a negative exponent:

   SELECT POW(2, -3);
   

   This will return 0.125 because 2 raised to the power of -3 is $\frac{1}{2^3} = 0.125$.

3. Using decimal values:

   SELECT POW(3.5, 2);
   

   This will return 12.25 because $3.5^2 = 12.25$.

The POW() function is often used in mathematical operations where exponentiation is needed.