log10

description

Syntax

DOUBLE log10(DOUBLE x) 返回以10为底的x的自然对数.

LOG10 - 图1提示

该函数的另一个别名为 dlog10

example

  1. mysql> select log10(1);
  2. +------------+
  3. | log10(1.0) |
  4. +------------+
  5. | 0 |
  6. +------------+
  7. mysql> select log10(10);
  8. +-------------+
  9. | log10(10.0) |
  10. +-------------+
  11. | 1 |
  12. +-------------+
  13. mysql> select log10(16);
  14. +--------------------+
  15. | log10(16.0) |
  16. +--------------------+
  17. | 1.2041199826559248 |
  18. +--------------------+

keywords

  1. LOG10, DLOG10