九、函数
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’);
个人学习笔记(慕课网),更多函数使用,查看官方文档