FORMAT(X,D)
FORMAT() 函数用于以下格式格式化数字X:###,###,###。##截断为D位小数。下面的例子演示Format()函数的使用和输出:
mysql>SELECT FORMAT(423423234.65434453,2); +---------------------------------------------------------+ | FORMAT(423423234.65434453,2) | +---------------------------------------------------------+ | 423,423,234.65 | +---------------------------------------------------------+ 1 row in set (0.00 sec)