摘要:
下文讲述MySQL数据库下TRUNCATE函数的用法简介说明,如下所示;
TRUNCATE()函数功能说明
TRUNCATE()函数:是MySQL数据库提供的系统函数,
它的功能对传入参数按保留位数进行数据截取
注意此函数是对数据直接截取,无四舍五入操作
TRUNCATE()函数语法:
TRUNCATE(X,D)
—–参数说明—–
X:待截取数值
D:保留位数
—–截取规则—–
1.当D大于0,只对数值的小数位数进行相关操作
2.当D等于0,只保留整数部分,删除所有小数部分
3.当D小于0,删除小数部分,将整数部分从左到右保留指定位数,其它位数全部用0替换
TRUNCATE()函数示例说明
mysql> select truncate(888.1256,3);
+----------------------+
| truncate(888.1256,3) |
+----------------------+
| 888.125 |
+----------------------+
1 row in set (0.00 sec)
mysql> select truncate(888.1256,2);
+----------------------+
| truncate(888.1256,2) |
+----------------------+
| 888.12 |
+----------------------+
1 row in set (0.00 sec)
mysql> select truncate(888.1256,0);
+----------------------+
| truncate(888.1256,0) |
+----------------------+
| 888 |
+----------------------+
1 row in set (0.00 sec)
mysql> select truncate(888.1256,-1);
+-----------------------+
| truncate(888.1256,-1) |
+-----------------------+
| 880 |
+-----------------------+
1 row in set (0.00 sec)
mysql> select truncate(888.1256,-2);
+-----------------------+
| truncate(888.1256,-2) |
+-----------------------+
| 800 |
+-----------------------+
1 row in set (0.00 sec)
mysql> select truncate(888.1256,-3);
+-----------------------+
| truncate(888.1256,-3) |
+-----------------------+
| 0 |
+-----------------------+
1 row in set (0.00 sec)