LOG10
log10β
descriptionβ
Syntaxβ
DOUBLE log10(DOUBLE x)
Returns the natural logarithm of x
to base 10
.
tip
Another alias for this function is dlog10
.
exampleβ
mysql> select log10(1);
+------------+
| log10(1.0) |
+------------+
| 0 |
+------------+
mysql> select log10(10);
+-------------+
| log10(10.0) |
+-------------+
| 1 |
+-------------+
mysql> select log10(16);
+--------------------+
| log10(16.0) |
+--------------------+
| 1.2041199826559248 |
+--------------------+
keywordsβ
LOG10, DLOG10