当数据库中有很多库与表结构时,有时候会忘记自己当前正在使用的是哪个数据库,用以下几种方法可以搞定。
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 wrapper
Connection id: 945018
Current database: monitor
Current user: UserDataAnalyze@10.10.10.10
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.1.66-log Source distribution
Protocol version: 10
Connection: yf-iknow-hive01.yf01 via TCP/IP
Server characterset: gbk
Db characterset: gbk
Client characterset: gbk
Conn. characterset: gbk
TCP port: 3306
Uptime: 7 days 7 hours 32 min 17 sec
Threads: 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)