search

Home >Database >Mysql Tutorial >mysql PI()函数获取圆周率的值

mysql PI()函数获取圆周率的值

WBOY
WBOYOriginal
2016-06-01 09:56:532455browse

PI()

返回 ϖ (pi)的值。默认的显示小数位数是7位,然而 MySQL内部会使用完全双精度值。

<code class="language-sql">mysql> SELECT PI();
        -> 3.141593

mysql> SELECT PI()+0.000000000000000000;
        -> 3.141592653589793116</code>

Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：mysql ORD()函数与ASCII()函数使用分析Next article：mysql 控制台如何结束当前写错的sql

Related articles

See more