mysql版本:5.7.22
mysql客户端这个选项:
-o, --one-database Ignore statements except those that occur while the
default database is the one named at the command line.
不知道年夜家是否熟悉。
经过实测,用下面的例子说明这个选项的含义吧。
[root@TEST~]# mysql --one-database mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 64
Server version: 5.7.22 MySQL Community Server (GPL)
Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> select * from sys.version;
+-------------+---------------+
| sys_version | mysql_version |
+-------------+---------------+
| 1.5.1 | 5.7.22 |
+-------------+---------------+
1 row in set (0.00 sec)
如果此时你切换到use sys,那么你再执行就会报错:
mysql> use sys
Database changed
mysql> select * from version;
Ignoring query to other database
实际上我们注意到,在执行use sys的时候,没有进行rehash操作。因为在普通模式下,一般存在如下的输出:
mysql> use sys
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
更多内容回复查看:
游客,如果您要查看本帖隐藏内容请回复