Mysql数据库函数(数字,字符串,日期时间)
数学函数
- abs(x) :返回x的绝对值
- rand() :返回0到1的随机数 注意:取不到1
- mod(x,y):返回x除以y以后的余数
- power(x,y):返回x的y次方
- round(x):返回离x最近的整数
- sqrt(x):返回x的平方根
- truncate(x,y):返回数字x截断为y位小数的值
- ceil(x):返回大于或等于x的最小整数 ## 注意:是向上取整数
- floor(x):返回小于或等于x的最大整数 ## 注意:是向下取整数
- greatest(x1,x2…):返回集合中最大的值
- least(x1,x2…):返回集合中最小的值
常用的数学函数
abs(x)返回x的绝对值
mysql> select abs(-1),abs(-3.14);
+---------+------------+
| abs(-1) | abs(-3.14) |
+---------+------------+
| 1 | 3.14 |
+---------+------------+
1 row in set (0.00 sec)
rand()返回0到1的随机数
mysql> select rand();
+--------------------+
| rand() |
+--------------------+
| 0.6230614116630158 |
+--------------------+
1 row in set (0.00 sec)
mod(x,y)返回x除以y以后的余数
mysql> select mod(10,3);
+-----------+
| mod(10,3) |
+-----------+
| 1 |
+-----------+
1 row in set (0.00 sec)
power(x,y)返回x的y次方
mysql> select power(3,2);
+------------+
| power(3,2) |
+------------+
| 9 |
+------------+
1 row in set (0.00 sec)
round(x)返回离x最近的整数
mysql> select round(1.49);
+-------------+
| round(1.49) |
+-------------+
| 1 |
+-------------+
round(x)返回离x最近的整数
mysql> select round(1.49);
+-------------+
| round(1.49) |
+-------------+
| 1 |
+-------------+
round(x,y)保留x的y位小数四舍五入后的值
mysql> select round(1.51);
+-------------+
| round(1.51) |
+-------------+
| 2 |
+-------------+
1 row in set (0.00 sec)
mysql> select round(1.51,1); 保留一位有效数字
+---------------+
| round(1.51,1) |
+---------------+
| 1.5 |
+---------------+
1 row in set (0.00 sec)
sqrt(x)返回x的平方根
mysql> select sqrt(4);
+---------+
| sqrt(4) |
+---------+
| 2 |
+---------