GBase 8a MPP基础 select 查看当前数据库

Server：CentOS Linux release 7.3.1611 (Core) （3.10.0-514.el7.x86_64）
GBase8a MPP Cluster：9.5.2.39-redhat7.3-x86_64
GBaseDataStudio：9.5.1.0_build2_Windows_x86_64

select 查看当前数据库

[gbase@localhost gcinstall]$ gccli -u root -p
Enter password: 

GBase client 9.5.2.39.126761. Copyright (c) 2004-2021, GBase.  All Rights Reserved.

gbase> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| performance_schema |
| gbase              |
| gctmpdb            |
| gclusterdb         |
| mydb               |
+--------------------+
6 rows in set (Elapsed: 00:00:00.00)

gbase> create database mydb2;
Query OK, 1 row affected (Elapsed: 00:00:00.02)

gbase> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| performance_schema |
| gbase              |
| gctmpdb            |
| gclusterdb         |
| mydb               |
| mydb2              |
+--------------------+
7 rows in set (Elapsed: 00:00:00.00)

gbase> use mydb2;
Query OK, 0 rows affected (Elapsed: 00:00:00.00)

gbase> select database();
+------------+
| database() |
+------------+
| mydb2      |
+------------+
1 row in set (Elapsed: 00:00:00.00)

gbase> use mydb;
Query OK, 0 rows affected (Elapsed: 00:00:00.00)

gbase> select database();
+------------+
| database() |
+------------+
| mydb       |
+------------+
1 row in set (Elapsed: 00:00:00.00)

gbase> 
复制

相关链接

• GBase培训中心
• 墨天轮社区

欢迎各位同学一起来交流学习心得！