MySQL数学函数简明总结(7)
2015-04-11 00:14 来源: 锦尚中国 点击:
mysql> select TRUNCATE(1.33,1), TRUNCATE(1.99,1), TRUNCATE(1.99,0), TRUNCATE(19.99,-1);
+------------------+------------------+------------------+--------------------+
| TRUNCATE(1.33,1) | TRUNCATE(1.99,1) | TRUNCATE(1.99,0) | TRUNCATE(19.99,-1) |
+------------------+------------------+------------------+--------------------+
| 1.3 | 1.9 | 1 | 10 |
+------------------+------------------+------------------+--------------------+
11. SIGN(X): 返回参数Ｘ的符号，Ｘ的值为负、零或正数时返回结果依次为－１，０或１
复制代码 代码如下:
