mysql 当前运行的命令 mysql 当前数据库

当使用某个用户登陆mysql后，如何查看当前的数据库呢

方法有三，分别如下：

 

1. 使用函数database()

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

 

2. 使用show tables \G

mysql> show tables \G
 *************************** 1. row ***************************
 Tables_in_example: department
 *************************** 2. row ***************************
 Tables_in_example: worker
 2 rows in set (0.00 sec)

 

3. 使用status

mysql> status
 --------------
 mysql  Ver 14.14 Distrib 5.6.14, for linux-glibc2.5 (x86_64) using  EditLine wrapperConnection id:          12
 Current database:       example
 Current user:            wang@localhost SSL:                    Not in use
 Current pager:          stdout
 Using outfile:          ''
 Using delimiter:        ;
 Server version:         5.6.14-enterprise-commercial-advanced MySQL Enterprise Server - Advanced Edition (Commercial)
 Protocol version:       10
 Connection:             Localhost via UNIX socket
 Server characterset:    gbk
 Db     characterset:    gbk
 Client characterset:    utf8
 Conn.  characterset:    utf8
 UNIX socket:            /tmp/mysql.sock
 Uptime:                 2 hours 6 min 56 secThreads: 2  Questions: 279  Slow queries: 0  Opens: 105  Flush tables: 1  Open tables: 84  Queries per second avg: 0.036

--------------