3)mysql 函数的使用

九、函数

9.1 字符函数

部分举例：

mysql> select concat('abc','def');
+---------------------+
| concat('abc','def') |
+---------------------+
| abcdef              |
+---------------------+
1 row in set (0.00 sec)

mysql> select concat_ws('-','ab','dc','des');
+--------------------------------+
| concat_ws('-','ab','dc','des') |
+--------------------------------+
| ab-dc-des                      |
+--------------------------------+
1 row in set (0.00 sec)

mysql> select format(100.31111,2);
+---------------------+
| format(100.31111,2) |
+---------------------+
| 100.31              |
+---------------------+
1 row in set (0.00 sec)

9.2 数值运算符与函数

部分举例：

mysql> select ceil(3.111);
+-------------+
| ceil(3.111) |
+-------------+
|           4 |
+-------------+
1 row in set (0.00 sec)

mysql> select floor(3.999);
+--------------+
| floor(3.999) |
+--------------+
|            3 |
+--------------+
1 row in set (0.00 sec)

mysql> select truncate(3.9999,2);
+--------------------+
| truncate(3.9999,2) |
+--------------------+
|               3.99 |
+--------------------+
1 row in set (0.00 sec)

mysql>

9.3 比较运算符与函数

9.4 日期函数

mysql> select date_add('2016-03-14',INTERVAL 30 DAY);
+----------------------------------------+
| date_add('2016-03-14',INTERVAL 30 DAY) |
+----------------------------------------+
| 2016-04-13                             |
+----------------------------------------+
1 row in set (0.00 sec)

mysql> select datediff('2016-03-14','2016-04-20');
+-------------------------------------+
| datediff('2016-03-14','2016-04-20') |
+-------------------------------------+
|                                 -37 |
+-------------------------------------+
1 row in set (0.00 sec)

mysql> select datediff('2016-03-14','2016-02-20');
+-------------------------------------+
| datediff('2016-03-14','2016-02-20') |
+-------------------------------------+
|                                  23 |
+-------------------------------------+
1 row in set (0.00 sec)

mysql> SELECT DATE_FORMAT('2014-3-12','%m/%d/%Y');
+-------------------------------------+
| DATE_FORMAT('2014-3-12','%m/%d/%Y') |
+-------------------------------------+
| 03/12/2014                          |
+-------------------------------------+
1 row in set (0.00 sec)

mysql>

9.5 信息函数

9.6 聚合函数

9.7 加密函数

加密函数
md5();//常用与web网页加密
paassword()//更改客户端的密码 set password=password（’asda’）；

个人学习笔记（慕课网），更多函数使用，查看官方文档