将逗号应用于 MySQL 中的数字字段
我有一列包含数字.是否可以使用功能使数字在服务器端以逗号显示?或者我需要在客户端使用 php 脚本吗?我更喜欢服务器端.
I have a column that contains numbers. Is it possible to make the numbers appear with a comma on Server-Side with a function? or do I need to this on the client side with a php script? I would prefer server-side.
提前致谢.
推荐答案
只要使用 MySQL 的 FORMAT()
函数
Just use MySQL's FORMAT()
function
mysql> SELECT FORMAT(12332.123456, 4);
-> '12,332.1235'
mysql> SELECT FORMAT(12332.1,4);
-> '12,332.1000'
mysql> SELECT FORMAT(12332.2,0);
-> '12,332'
mysql> SELECT FORMAT(12332.2,2,'de_DE');
-> '12.332,20'
或者 PHP 的 number_format()
一个>
Or PHP's number_format()
<?php
$number = 1234.56;
// english notation (default)
$english_format_number = number_format($number);
// 1,235
// French notation
$nombre_format_francais = number_format($number, 2, ',', ' ');
// 1 234,56
$number = 1234.5678;
// english notation without thousands separator
$english_format_number = number_format($number, 2, '.', '');
// 1234.57
?>
相关文章