MySQL的format函数用法详解

format函数在mysql中是数据内容格式化的,下面我来给各位介绍此函数的基本用法,希望此文章对各位所有帮助.

FORMAT()函数是用来在以下格式来格式化数X:＃＃＃,＃＃＃,＃＃＃＃＃截断至D位小数,下面的例子演示了如何使用和输出的FORMAT()函数,代码如下:

1. mysql>SELECTFORMAT(423423234.65434453,2);
2. +---------------------------------------------------------+
3. |FORMAT(423423234.65434453,2)|
4. +---------------------------------------------------------+
5. |423,423,234.65|
6. +---------------------------------------------------------+
7. 1rowinset(0.00sec)

mysql的format函数,可以格式化数据为整数或者浮点数,代码如下:

1. mysql>selectformat(100.31111,2);
2. +---------------------+
3. |format(100.31111,2)|
4. +---------------------+
5. |100.31|
6. +---------------------+
7. 1rowinset(0.00sec)
9. mysql>selectformat(100.31111,0);
10. +---------------------+
11. |format(100.31111,0)|
12. +---------------------+
13. |100|
14. +---------------------+
15. 1rowinset(0.00sec)
17. mysql>selectformat(100.51111,0);
18. +---------------------+
19. |format(100.51111,0)|
20. +---------------------+
21. |101|--phpfensi.com
22. +---------------------+
23. 1rowinset(0.00sec)