摘要:
下文MySQL数据库中求一个数的绝对值方法分享,如下所示;
实现思路:
MySQL数据库中借助ABS函数即可求数字的绝对值
注意事项:
当输入一个非数字型的数据时,
ABS将返回0
例:
mysql> select abs(-10),abs(10),abs(0.99);
+----------+---------+-----------+
| abs(-10) | abs(10) | abs(0.99) |
+----------+---------+-----------+
| 10 | 10 | 0.99 |
+----------+---------+-----------+
1 row in set (0.00 sec)
mysql> select abs('m'),abs('maomao365.com'),abs('www');
+----------+----------------------+------------+
| abs('m') | abs('maomao365.com') | abs('www') |
+----------+----------------------+------------+
| 0 | 0 | 0 |
+----------+----------------------+------------+
1 row in set, 3 warnings (0.00 sec)