MYSQL下查看当前正在使用的数据库

来源：互联网发布：mac怎么下载windows 编辑：程序博客网时间：2024/06/18 15:56

当数据库中有很多库与表结构时，有时候会忘记自己当前正在使用的是哪个数据库，用以下几种方法可以搞定。

mysql> show tables;+-------------------+| Tables_in_monitor |+-------------------+| crm_access        || schema_table_info |+-------------------+2 rows in set (0.00 sec)

1. select databases();

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

2. status;

mysql> status;--------------/home/iknow/mysql51/bin/mysql  Ver 14.14 Distrib 5.1.66, for unknown-linux-gnu (x86_64) using  EditLine wrapperConnection id:          945018Current database:       monitorCurrent user:           UserDataAnalyze@10.10.10.10SSL:                    Not in useCurrent pager:          stdoutUsing outfile:          ''Using delimiter:        ;Server version:         5.1.66-log Source distributionProtocol version:       10Connection:             yf-iknow-hive01.yf01 via TCP/IPServer characterset:    gbkDb     characterset:    gbkClient characterset:    gbkConn.  characterset:    gbkTCP port:               3306Uptime:                 7 days 7 hours 32 min 17 secThreads: 28  Questions: 144337869  Slow queries: 232245  Opens: 14146  Flush tables: 3  Open tables: 512  Queries per second avg: 228.405--------------

3. show tables;

mysql> show tables;+-------------------+| Tables_in_monitor |+-------------------+| crm_access        || schema_table_info |+-------------------+2 rows in set (0.01 sec)

1 0