SQRT() - Square Root of X

Q

How to calculate the square root of a given number using the SQRT() function?

✍: FYIcenter.com

A

SQRT(X) is a MySQL built-in function that calculates the square root of a given number. For example:

SELECT SQRT(2), SQRT(4), SQRT(8);
  -- +--------------------+---------+--------------------+
  -- | SQRT(2)            | SQRT(4) | SQRT(8)            |
  -- +--------------------+---------+--------------------+
  -- | 1.4142135623730951 |       2 | 2.8284271247461903 |
  -- +--------------------+---------+--------------------+

Reference information of the SQRT() function:

SQRT(X): val
  Returns the square root of a nonnegative number X.

Arguments, return value and availability:
  X: Required. The input number.
  val: Return value. The square root of X.
  Available since MySQL 4.0.

 

TAN() - Tangent Trigonometric Value

SIN() - Sine Trigonometric Value

MySQL Functions on Numeric Values

⇑⇑ MySQL Function References

2023-11-14, 327🔥, 0💬