SQL中常用函数的使用

1、普通的常用函数

1.version()          # 用来查询当前数据库的版本

mysql> select version();
+-----------+
| version() |
+-----------+
| 5.7.14    |
+-----------+
1 row in set (0.27 sec)

2.user()                # 查询当前登录用户

mysql> select user();
+----------------+
| user()         |
+----------------+
| root@localhost |
+----------------+
1 row in set (0.10 sec)

3.database()        # 查询当前所在的数据库

mysql> select database();
+------------+
| database() |
+------------+
| db_yckd    |
+------------+
1 row in set (0.00 sec)

4.uuid()                # 返回uuid的值，分布式情况下数据库主键不重复的解决方案

mysql> select uuid();
+--------------------------------------+
| uuid()                               |
+--------------------------------------+
| b5d85a03-0d4b-11eb-8250-000c293dcf91 |
+--------------------------------------+
1 row in set (0.16 sec)

2、聚合函数

mysql> select id from student;
+-----+
| id  |
+-----+
| 901 |
| 902 |
| 903 |
| 904 |
| 905 |
| 906 |
+-----+
6 rows in set (0.01 sec)

1.count(列名称)         # 统计总共有多少行行

mysql> select count(id) from student;
+-----------+
| count(id) |
+-----------+
|         6 |
+-----------+
1 row in set (0.00 sec)

2.max(列名称)           # 最大值

mysql> select max(id) from student;
+---------+
| max(id) |
+---------+
|     906 |
+---------+
1 row in set (0.00 sec)

3.min(列名称)            # 最小值

mysql> select min(id) from student;
+---------+
| min(id) |
+---------+
|     901 |
+---------+
1 row in set (0.00 sec)

4.sum(列名称)           # 求和统计

mysql> select sum(id) from student;
+---------+