MySql常用(一、字符串和数值)函数
5.1字符串函数
mysql> SELECT FORMAT(12332, 4);+------------------+| FORMAT(12332, 4) |+------------------+| 12,332.0000 |+------------------+1 row in set (0.00 sec)mysql> SELECT FORMAT(12332.123456, 0);+-------------------------+| FORMAT(12332.123456, 0) |+-------------------------+| 12,332 |+-------------------------+1 row in set (0.00 sec)mysql> SELECT FORMAT(12332.123456, 4);+-------------------------+| FORMAT(12332.123456, 4) |+-------------------------+| 12,332.1235 |+-------------------------+1 row in set (0.00 sec)mysql> select FORMAT(t, 4) from myfloat;+--------------+| FORMAT(t, 4) |+--------------+| 1.0123 || 2.0123 || 3.0123 |+--------------+3 rows in set (0.02 sec)mysql> select rand() * 10;+-----------------+| rand() * 10 |+-----------------+| 4.9611047422151 |+-----------------+1 row in set (0.00 sec)mysql> select floor(rand() * 10);+--------------------+| floor(rand() * 10) |+--------------------+| 1 |+--------------------+1 row in set (0.00 sec)mysql> select truncate(1.0123456789, 4);+---------------------------+| truncate(1.0123456789, 4) |+---------------------------+| 1.0123 |+---------------------------+1 row in set (0.00 sec)mysql> select truncate(1.0123456789, 0);+---------------------------+| truncate(1.0123456789, 0) |+---------------------------+| 1 |+---------------------------+1 row in set (0.00 sec)mysql> select truncate(123456.0123456789, -5);+---------------------------------+| truncate(123456.0123456789, -5) |+---------------------------------+| 100000 |+---------------------------------+1 row in set (0.00 sec)
