最近因为工作的需求，需要对mysql中数字进行格式化，但发现网上的资料较少，索性自己总结一下，方便自己也帮助有需要的朋友们，下面话不多说，来一起看看详细的介绍： [b]一、format函数：[/b] 格式化浮点数 [code]format(number, length);[/code] [b]介绍：[/b]Formats the number X to a format like '#,###,###.##', rounded to D decimal places, and returns the result as a string. If D is 0, the result has no decimal point or fractional part. D should be a constant value. [b]示例代码[/b] [b]二、rpad 和 lpad 给定位数，不足补充自定义字符[/b] [b]RPAD:[/b] Returns the string str,right-padded with the string padstr to a length of len characters. If str is longer than len, the return value is shortened to len characters.       示例代码   This function is multi-byte safe. [b]LPAD:[/b] Returns the string str, left-padded with the string padstr to a length of lencharacters. If str is longer than len, the return value is shortened to lencharacters. 示例代码 参考：http://www.cnblogs.com/fenglie/articles/4409208.html [b]总结[/b] 以上就是这篇文章的全部内容了，希望本文的内容对大家的学习或者工作能带来一定的帮助，如果有疑问大家可以留言交流，谢谢大家对编程素材网的支持。