MySQL系统函数

最新推荐文章于 2024-04-02 21:45:19 发布

xujiali5172923

最新推荐文章于 2024-04-02 21:45:19 发布

阅读量379

点赞数

分类专栏： mysql 文章标签： mysql

本文链接：https://blog.csdn.net/xujiali5172923/article/details/50558022

版权

mysql 专栏收录该内容

31 篇文章 0 订阅

订阅专栏

1.查看MySQL版本号

mysql> select version();
+-----------+
| version() |
+-----------+
| 5.1.73    |
+-----------+
1 row in set (0.13 sec)

2.查看当前用户连接数

mysql> select connection_id();
+-----------------+
| connection_id() |
+-----------------+
|              15 |
+-----------------+
1 row in set (0.01 sec)

3.使用SHOW PROCESSLIST命令输出当前用户的连接信息

mysql> show processlist;
+----+------+-----------+------+---------+------+-------+------------------+
| Id | User | Host      | db   | Command | Time | State | Info             |
+----+------+-----------+------+---------+------+-------+------------------+
| 16 | root | localhost | NULL | Query   |    0 | NULL  | show processlist |
+----+------+-----------+------+---------+------+-------+------------------+
1 row in set (0.02 sec)

4.查看当前使用的数据库

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

5.获取当前登录用户名

mysql> select user(),current_user(),system_user();
+----------------+----------------+----------------+
| user()         | current_user() | system_user()  |
+----------------+----------------+----------------+
| root@localhost | root@localhost | root@localhost |
+----------------+----------------+----------------+
1 row in set (0.00 sec)