南大通用数据库-Gbase-8a-学习-32-gccli客户端

阳光九叶草LXGZXJ

已于 2023-04-20 13:38:44 修改

阅读量895

点赞数 2

分类专栏： # Gbase-8a-学习文章标签：数据库 sql database 学习

于 2023-03-29 14:39:25 首次发布

本文链接：https://blog.csdn.net/qq_45111959/article/details/129830221

版权

Gbase-8a-学习专栏收录该内容

44 篇文章 20 订阅

订阅专栏

一、测试环境

名称	值
CPU	Intel(R) Core(TM) i5-1035G1 CPU @ 1.00GHz
操作系统	CentOS Linux release 7.9.2009 (Core)
内存	3G
逻辑核数	2
Gbase8a版本	8.6.2-R43

二、参数介绍

1、-u

（1）含义

表示连接数据库的用户名。

（2）例子

[gbase@czg2 ~]$ gccli -u root

GBase client 8.6.2-R43.34.27468a27. Copyright (c) 2004-2023, GBase.  All Rights Reserved.

gbase>

2、-h

（1）含义

表示登录数据库节点的 IP ，默认为本地，为可选参数。支持高可用，IP 之间用逗号分隔。

（2）例子

[gbase@czg2 ~]$ gcadmin
CLUSTER STATE:  ACTIVE
CLUSTER MODE:   NORMAL

=====================================================================
|               GBASE COORDINATOR CLUSTER INFORMATION               |
=====================================================================
|   NodeName   |       IpAddress       |gcware |gcluster |DataState |
---------------------------------------------------------------------
| coordinator1 |    192.168.142.12     | OPEN  |  OPEN   |    0     |
---------------------------------------------------------------------
=================================================================
|                GBASE DATA CLUSTER INFORMATION                 |
=================================================================
|NodeName |       IpAddress       |gnode |syncserver |DataState |
-----------------------------------------------------------------
|  node1  |    192.168.142.12     | OPEN |   OPEN    |    0     |
-----------------------------------------------------------------
[gbase@czg2 ~]$ gccli -h 192.168.142.11,192.168.142.12
ERROR 2003 (HY000): Can't connect to GBase server on '192.168.142.11' (113)

GBase client 8.6.2-R43.34.27468a27. Copyright (c) 2004-2023, GBase.  All Rights Reserved.

gbase>

3、-P

（1）含义

数据库集群层的端口号，默认为5258，为可选参数。

（2）例子

实际测试不生效这个版本，可能后续修复这个错误。

[gbase@czg2 ~]$ gccli 

GBase client 8.6.2-R43.34.27468a27. Copyright (c) 2004-2023, GBase.  All Rights Reserved.

gbase> show variables like'port%';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| port          | 5258  |
+---------------+-------+
1 row in set (Elapsed: 00:00:00.00)

gbase> quit
Bye
[gbase@czg2 ~]$ gccli -P 5258

GBase client 8.6.2-R43.34.27468a27. Copyright (c) 2004-2023, GBase.  All Rights Reserved.

gbase> quit
Bye
[gbase@czg2 ~]$ gccli -P 999999

GBase client 8.6.2-R43.34.27468a27. Copyright (c) 2004-2023, GBase.  All Rights Reserved.

gbase> quit
Bye

4、-D

（1）含义

指定登录的数据库名，可选参数。

（2）例子

[gbase@czg2 ~]$ gccli

GBase client 8.6.2-R43.34.27468a27. Copyright (c) 2004-2023, GBase.  All Rights Reserved.

gbase> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| performance_schema |
| bd_db_a141         |
| czg                |
| gbase              |
| gclusterdb         |
| gctmpdb            |
| zxj                |
+--------------------+
8 rows in set (Elapsed: 00:00:00.08)

gbase> quit
Bye
[gbase@czg2 ~]$ gccli -D czg

GBase client 8.6.2-R43.34.27468a27. Copyright (c) 2004-2023, GBase.  All Rights Reserved.

gbase> quit
Bye
[gbase@czg2 ~]$ gccli -D hahah
ERROR 1049 (42000): Unknown database 'hahah'

5、--nice_time_form

（1）含义

执行操作时，由原来的秒精确到毫秒。可选参数。

（2）例子

[gbase@czg2 ~]$ gccli 

GBase client 8.6.2-R43.34.27468a27. Copyright (c) 2004-2023, GBase.  All Rights Reserved.

gbase> select * from czg.testtab_copy limit 1;
+------+------+------+--------------------+--------------------+--------------------------+------------+---------------------+
| a    | b    | c    | d                  | e                  | f                        | g          | h                   |
+------+------+------+--------------------+--------------------+--------------------------+------------+---------------------+
|    1 |  1.1 | czg  | 快乐的小天使       | qwertasdsdfzxczxxv | gregergjsfishfuieehfuiew | 1995-09-18 | 2023-03-07 16:48:57 |
+------+------+------+--------------------+--------------------+--------------------------+------------+---------------------+
1 row in set (Elapsed: 00:00:00.01)

gbase> quit
Bye
[gbase@czg2 ~]$ gccli --nice_time_forma

GBase client 8.6.2-R43.34.27468a27. Copyright (c) 2004-2023, GBase.  All Rights Reserved.

gbase> select * from czg.testtab_copy limit 1;
+------+------+------+--------------------+--------------------+--------------------------+------------+---------------------+
| a    | b    | c    | d                  | e                  | f                        | g          | h                   |
+------+------+------+--------------------+--------------------+--------------------------+------------+---------------------+
|    1 |  1.1 | czg  | 快乐的小天使       | qwertasdsdfzxczxxv | gregergjsfishfuieehfuiew | 1995-09-18 | 2023-03-07 16:48:57 |
+------+------+------+--------------------+--------------------+--------------------------+------------+---------------------+
1 row in set (0.02 sec)

gbase> quit
Bye

6、-c

（1）含义

支持hint，不加则过滤注释信息。

（2）例子

_gbase_result_threshold参数为限制返回结果集行数。

[gbase@czg2 ~]$ gccli 

GBase client 8.6.2-R43.34.27468a27. Copyright (c) 2004-2023, GBase.  All Rights Reserved.

gbase> select * from czg.testtab_copy limit 10;
+------+------+------+--------------------+--------------------+--------------------------+------------+---------------------+
| a    | b    | c    | d                  | e                  | f                        | g          | h                   |
+------+------+------+--------------------+--------------------+--------------------------+------------+---------------------+
|    1 |  1.1 | czg  | 快乐的小天使       | qwertasdsdfzxczxxv | gregergjsfishfuieehfuiew | 1995-09-18 | 2023-03-07 16:48:57 |
|    2 |  1.1 | czg  | 快乐的小天使       | qwertasdsdfzxczxxv | gregergjsfishfuieehfuiew | 1995-09-18 | 2023-03-07 16:48:57 |
|    3 |  1.1 | czg  | 快乐的小天使       | qwertasdsdfzxczxxv | gregergjsfishfuieehfuiew | 1995-09-18 | 2023-03-07 16:48:57 |
|    1 |  1.1 | czg  | 快乐的小天使       | qwertasdsdfzxczxxv | gregergjsfishfuieehfuiew | 1995-09-18 | 2023-03-07 16:48:57 |
|    2 |  1.1 | czg  | 快乐的小天使       | qwertasdsdfzxczxxv | gregergjsfishfuieehfuiew | 1995-09-18 | 2023-03-07 16:48:57 |
|    3 |  1.1 | czg  | 快乐的小天使       | qwertasdsdfzxczxxv | gregergjsfishfuieehfuiew | 1995-09-18 | 2023-03-07 16:48:57 |
|    1 |  1.1 | czg  | 快乐的小天使       | qwertasdsdfzxczxxv | gregergjsfishfuieehfuiew | 1995-09-18 | 2023-03-07 16:48:57 |
|    2 |  1.1 | czg  | 快乐的小天使       | qwertasdsdfzxczxxv | gregergjsfishfuieehfuiew | 1995-09-18 | 2023-03-07 16:48:57 |
|    3 |  1.1 | czg  | 快乐的小天使       | qwertasdsdfzxczxxv | gregergjsfishfuieehfuiew | 1995-09-18 | 2023-03-07 16:48:57 |
|    1 |  1.1 | czg  | 快乐的小天使       | qwertasdsdfzxczxxv | gregergjsfishfuieehfuiew | 1995-09-18 | 2023-03-07 16:48:57 |
+------+------+------+--------------------+--------------------+--------------------------+------------+---------------------+
10 rows in set (Elapsed: 00:00:00.01)

gbase> quit
Bye
[gbase@czg2 ~]$ gccli -c

GBase client 8.6.2-R43.34.27468a27. Copyright (c) 2004-2023, GBase.  All Rights Reserved.

gbase> select /*+_gbase_result_threshold(4)*/* from czg.testtab_copy limit 10;
ERROR 1708 (HY000): [192.168.142.12:5050](GBA-02AD-0005)Failed to query in gnode:
DETAIL: (GBA-01EX-0006) Express out of resources error:Too many tuples.
SQL: SELECT /*::ffff:192.168.142.12_56_1_2023-03-29_11:05:56*/ /*+ TID('9240616') */  /*+ local _gbase_result_threshold(4) */ `czg.testtab_copy`.`a` AS `a`, `czg.testtab_copy`.`b` AS `b`, `czg.testtab_copy`.`c` AS `c`, `czg.testtab_copy`.`d` AS `d`, `czg.testtab_copy`.`e` AS `e`, `czg.testtab_copy`.`f` AS `f`, `czg.testtab_copy`.`g` AS `g`, `czg.testtab_copy`.`h` AS `h` FROM

7、-f

（1）含义

批量执行 SQL 文件时，如果中间有 SQL 执行报错，强制执行后续 SQL，可选参数；

（2）例子

[gbase@czg2 ~]$ cat Sql.txt 
select * from czg.testtab_copy limit 1;
select /*+_gbase_result_threshold(4)*/* from czg.testtab_copy limit 10;
select * from czg.testtab_copy limit 1;

[gbase@czg2 ~]$ gccli -c -f < Sql.txt 
a       b       c       d       e       f       g       h
1       1.1     czg     快乐的小天使    qwertasdsdfzxczxxv      gregergjsfishfuieehfuiew        1995-09-18      2023-03-07 16:48:57
ERROR 1708 (HY000) at line 2: [192.168.142.12:5050](GBA-02AD-0005)Failed to query in gnode:
DETAIL: (GBA-01EX-0006) Express out of resources error:Too many tuples.
SQL: SELECT /*::ffff:192.168.142.12_70_2_2023-03-29_11:18:39*/ /*+ TID('9240630') */  /*+ local _gbase_result_threshold(4) */ `czg.testtab_copy`.`a` AS `a`, `czg.testtab_copy`.`b` AS `b`, `czg.testtab_copy`.`c` AS `c`, `czg.testtab_copy`.`d` AS `d`, `czg.testtab_copy`.`e` AS `e`, `czg.testtab_copy`.`f` AS `f`, `czg.testtab_copy`.`g` AS `g`, `czg.testtab_copy`.`h` AS `h` FROM
a       b       c       d       e       f       g       h
1       1.1     czg     快乐的小天使    qwertasdsdfzxczxxv      gregergjsfishfuieehfuiew        1995-09-18      2023-03-07 16:48:57

[gbase@czg2 ~]$ gccli -c  < Sql.txt 
a       b       c       d       e       f       g       h
1       1.1     czg     快乐的小天使    qwertasdsdfzxczxxv      gregergjsfishfuieehfuiew        1995-09-18      2023-03-07 16:48:57
ERROR 1708 (HY000) at line 2: [192.168.142.12:5050](GBA-02AD-0005)Failed to query in gnode:
DETAIL: (GBA-01EX-0006) Express out of resources error:Too many tuples.
SQL: SELECT /*::ffff:192.168.142.12_71_2_2023-03-29_11:19:55*/ /*+ TID('9240633') */  /*+ local _gbase_result_threshold(4) */ `czg.testtab_copy`.`a` AS `a`, `czg.testtab_copy`.`b` AS `b`, `czg.testtab_copy`.`c` AS `c`, `czg.testtab_copy`.`d` AS `d`, `czg.testtab_copy`.`e` AS `e`, `czg.testtab_copy`.`f` AS `f`, `czg.testtab_copy`.`g` AS `g`, `czg.testtab_copy`.`h` AS `h` FROM

8、-v

（1）含义

提示更多信息。

（2）例子

[gbase@czg2 ~]$ gccli

GBase client 8.6.2-R43.34.27468a27. Copyright (c) 2004-2023, GBase.  All Rights Reserved.

gbase> select * from czg.testtab_copy limit 1;
+------+------+------+--------------------+--------------------+--------------------------+------------+---------------------+
| a    | b    | c    | d                  | e                  | f                        | g          | h                   |
+------+------+------+--------------------+--------------------+--------------------------+------------+---------------------+
|    1 |  1.1 | czg  | 快乐的小天使       | qwertasdsdfzxczxxv | gregergjsfishfuieehfuiew | 1995-09-18 | 2023-03-07 16:48:57 |
+------+------+------+--------------------+--------------------+--------------------------+------------+---------------------+
1 row in set (Elapsed: 00:00:00.01)

gbase> quit
Bye
[gbase@czg2 ~]$ gccli -v

GBase client 8.6.2-R43.34.27468a27. Copyright (c) 2004-2023, GBase.  All Rights Reserved.

Reading history-file /home/gbase/.gbase_history
gbase> select * from czg.testtab_copy limit 1;
--------------
select * from czg.testtab_copy limit 1
--------------

+------+------+------+--------------------+--------------------+--------------------------+------------+---------------------+
| a    | b    | c    | d                  | e                  | f                        | g          | h                   |
+------+------+------+--------------------+--------------------+--------------------------+------------+---------------------+
|    1 |  1.1 | czg  | 快乐的小天使       | qwertasdsdfzxczxxv | gregergjsfishfuieehfuiew | 1995-09-18 | 2023-03-07 16:48:57 |
+------+------+------+--------------------+--------------------+--------------------------+------------+---------------------+
1 row in set (Elapsed: 00:00:00.01)

gbase> quit

9、-V

（1）含义

输出版本信息，退出程序。

（2）例子

[gbase@czg2 ~]$ gccli -V
gccli ver 8.6.2-R43.34.27468a27, for redhat-linux (x86_64) using readline 6.3

10、-E

（1）含义

垂直输出每一行的信息，和\G有异曲同工之妙。

（2）例子

[gbase@czg2 ~]$ gccli -E

GBase client 8.6.2-R43.34.27468a27. Copyright (c) 2004-2023, GBase.  All Rights Reserved.

gbase> select * from czg.testtab_copy limit 1;
*************************** 1. row ***************************
a: 1
b: 1.1
c: czg
d: 快乐的小天使
e: qwertasdsdfzxczxxv
f: gregergjsfishfuieehfuiew
g: 1995-09-18
h: 2023-03-07 16:48:57
1 row in set (Elapsed: 00:00:00.01)

[gbase@czg2 ~]$ gccli 

GBase client 8.6.2-R43.34.27468a27. Copyright (c) 2004-2023, GBase.  All Rights Reserved.

gbase> select * from czg.testtab_copy limit 1\G;
*************************** 1. row ***************************
a: 1
b: 1.1
c: czg
d: 快乐的小天使
e: qwertasdsdfzxczxxv
f: gregergjsfishfuieehfuiew
g: 1995-09-18
h: 2023-03-07 16:48:57
1 row in set (Elapsed: 00:00:00.01)

ERROR: 
No query specified

11、-e

（1）含义

可以执行单个或多个语句并退出程序，以分号隔开，可选参数；

（2）例子

[gbase@czg2 ~]$ gccli -e 'select * from czg.testtab_copy limit 1\G; select * from czg.testtab_copy limit 1\G;'
*************************** 1. row ***************************
a: 1
b: 1.1
c: czg
d: 快乐的小天使
e: qwertasdsdfzxczxxv
f: gregergjsfishfuieehfuiew
g: 1995-09-18
h: 2023-03-07 16:48:57
*************************** 1. row ***************************
a: 1
b: 1.1
c: czg
d: 快乐的小天使
e: qwertasdsdfzxczxxv
f: gregergjsfishfuieehfuiew
g: 1995-09-18
h: 2023-03-07 16:48:57

12、-s

（1）含义

输出信息减少。

（2）例子

[gbase@czg2 ~]$ gccli -s
gbase> select * from czg.testtab_copy limit 1\G;
*************************** 1. row ***************************
a: 1
b: 1.1
c: czg
d: 快乐的小天使
e: qwertasdsdfzxczxxv
f: gregergjsfishfuieehfuiew
g: 1995-09-18
h: 2023-03-07 16:48:57
ERROR: 
No query specified

13、-N

（1）含义

显示SQL执行结果时，不输出列名。

（2）例子

[gbase@czg2 ~]$ gccli -N

GBase client 8.6.2-R43.34.27468a27. Copyright (c) 2004-2023, GBase.  All Rights Reserved.

gbase> select * from czg.testtab_copy limit 1;
+------+------+------+--------------------+--------------------+--------------------------+------------+---------------------+
|    1 | 1.1  | czg  | 快乐的小天使       | qwertasdsdfzxczxxv | gregergjsfishfuieehfuiew | 1995-09-18 | 2023-03-07 16:48:57 |
+------+------+------+--------------------+--------------------+--------------------------+------------+---------------------+
1 row in set (Elapsed: 00:00:00.01)

gbase> quit
Bye
[gbase@czg2 ~]$ gccli 

GBase client 8.6.2-R43.34.27468a27. Copyright (c) 2004-2023, GBase.  All Rights Reserved.

gbase> select * from czg.testtab_copy limit 1;
+------+------+------+--------------------+--------------------+--------------------------+------------+---------------------+
| a    | b    | c    | d                  | e                  | f                        | g          | h                   |
+------+------+------+--------------------+--------------------+--------------------------+------------+---------------------+
|    1 |  1.1 | czg  | 快乐的小天使       | qwertasdsdfzxczxxv | gregergjsfishfuieehfuiew | 1995-09-18 | 2023-03-07 16:48:57 |
+------+------+------+--------------------+--------------------+--------------------------+------------+---------------------+
1 row in set (Elapsed: 00:00:00.01)

14、-H

（1）含义

显示SQL执行结果以HTML形式输出。

（2）例子

[gbase@czg2 ~]$ gccli -H

GBase client 8.6.2-R43.34.27468a27. Copyright (c) 2004-2023, GBase.  All Rights Reserved.

gbase> select * from czg.testtab_copy limit 10;
<TABLE BORDER=1><TR><TH>a</TH><TH>b</TH><TH>c</TH><TH>d</TH><TH>e</TH><TH>f</TH><TH>g</TH><TH>h</TH></TR><TR><TD>1</TD><TD>1.1</TD><TD>czg</TD><TD>快乐的小天使</TD><TD>qwertasdsdfzxczxxv</TD><TD>gregergjsfishfuieehfuiew</TD><TD>1995-09-18</TD><TD>2023-03-07 16:48:57</TD></TR><TR><TD>2</TD><TD>1.1</TD><TD>czg</TD><TD>快乐的小天使</TD><TD>qwertasdsdfzxczxxv</TD><TD>gregergjsfishfuieehfuiew</TD><TD>1995-09-18</TD><TD>2023-03-07 16:48:57</TD></TR><TR><TD>3</TD><TD>1.1</TD><TD>czg</TD><TD>快乐的小天使</TD><TD>qwertasdsdfzxczxxv</TD><TD>gregergjsfishfuieehfuiew</TD><TD>1995-09-18</TD><TD>2023-03-07 16:48:57</TD></TR><TR><TD>1</TD><TD>1.1</TD><TD>czg</TD><TD>快乐的小天使</TD><TD>qwertasdsdfzxczxxv</TD><TD>gregergjsfishfuieehfuiew</TD><TD>1995-09-18</TD><TD>2023-03-07 16:48:57</TD></TR><TR><TD>2</TD><TD>1.1</TD><TD>czg</TD><TD>快乐的小天使</TD><TD>qwertasdsdfzxczxxv</TD><TD>gregergjsfishfuieehfuiew</TD><TD>1995-09-18</TD><TD>2023-03-07 16:48:57</TD></TR><TR><TD>3</TD><TD>1.1</TD><TD>czg</TD><TD>快乐的小天使</TD><TD>qwertasdsdfzxczxxv</TD><TD>gregergjsfishfuieehfuiew</TD><TD>1995-09-18</TD><TD>2023-03-07 16:48:57</TD></TR><TR><TD>1</TD><TD>1.1</TD><TD>czg</TD><TD>快乐的小天使</TD><TD>qwertasdsdfzxczxxv</TD><TD>gregergjsfishfuieehfuiew</TD><TD>1995-09-18</TD><TD>2023-03-07 16:48:57</TD></TR><TR><TD>2</TD><TD>1.1</TD><TD>czg</TD><TD>快乐的小天使</TD><TD>qwertasdsdfzxczxxv</TD><TD>gregergjsfishfuieehfuiew</TD><TD>1995-09-18</TD><TD>2023-03-07 16:48:57</TD></TR><TR><TD>3</TD><TD>1.1</TD><TD>czg</TD><TD>快乐的小天使</TD><TD>qwertasdsdfzxczxxv</TD><TD>gregergjsfishfuieehfuiew</TD><TD>1995-09-18</TD><TD>2023-03-07 16:48:57</TD></TR><TR><TD>1</TD><TD>1.1</TD><TD>czg</TD><TD>快乐的小天使</TD><TD>qwertasdsdfzxczxxv</TD><TD>gregergjsfishfuieehfuiew</TD><TD>1995-09-18</TD><TD>2023-03-07 16:48:57</TD></TR></TABLE>10 rows in set (Elapsed: 00:00:00.01)

15、-L

（1）含义

错误信息中不写行号。

（2）例子

没有模拟出来。

16、-p

（1）含义

登录数据库的用户名密码。

（2）例子

[gbase@czg2 ~]$ gccli -u czg -pqwer1234

GBase client 8.6.2-R43.34.27468a27. Copyright (c) 2004-2023, GBase.  All Rights Reserved.

gbase> quit
Bye
[gbase@czg2 ~]$ gccli -u czg -p
Enter password: 

GBase client 8.6.2-R43.34.27468a27. Copyright (c) 2004-2023, GBase.  All Rights Reserved.

gbase>

阳光九叶草LXGZXJ

关注

2
点赞
踩
3

收藏

觉得还不错? 一键收藏
1
评论
南大通用数据库-Gbase-8a-学习-32-gccli客户端

介绍南大通用-Gbase8a-gccli工具的参数含义与示例，参数列表如下：1、-u;2、-h;3、-P;4、-D;5、--nice_time_form;6、-c;7、-f;8、-v;9、-V;10、-E;11、-e;12、-s;13、-N;14、-H;15、-L;16、-p;
复制链接

扫一扫