MySQL常用数据库函数

一. 常用的函数分类
• 数学函数
• 聚合函数
• 字符串函数
• 日期时间函数

二. 常用的数学函数
1.rand() 返回0到1的随机数

mysql> select rand();
+--------------------+
| rand()             |
+--------------------+
| 0.2819034413266028 |
+--------------------+
1 row in set (0.00 sec)

2. mod(x,y) 返回x除以y以后的余数:

mysql> select mod(7,3);
+----------+
| mod(7,3) |
+----------+
|        1 |
+----------+
1 row in set (0.00 sec)

3.round(x) 返回离x最近的整数

mysql> select round(1.8);
+------------+
| round(1.8) |
+------------+
|          2 |
+------------+
1 row in set (0.00 sec)

4.round(x,y) 保留x的y位小数四舍五入后的值:

mysql> select round(1.78,1);
+---------------+
| round(1.78,1) |
+---------------+
|           1.8 |
+---------------+
1 row in set (0.00 sec)

5.truncate(x,y) 返回数字x截断为y位小数的值

mysql> select truncate(3.12345,3);
+---------------------+
| truncate(3.12345,3) |
+---------------------+
|               3.123 |
+---------------------+
1 row in set (0.00 sec)

6.ceil(x) 返回大于或等于x的最小整数

mysql> select ceil(1.09); // 向下取整
+------------+
| ceil(1.09) |
+------------+
|          2 |
+------------+
1 row in set (0.00 sec)

7.floor(x) 返回小于或等于x的最大整数

mysql> select floor(1.08);
+-------------+
| floor(1.08) |
+-------------+
|           1 |
+-------------+
1 row in