南大通用数据库-Gbase-8a-学习-32-gccli客户端
目录
一、测试环境
二、参数介绍
1、-u
(1)含义
(2)例子
2、-h
(1)含义
(2)例子
3、-P
(1)含义
(2)例子
4、-D
(1)含义
(2)例子
5、--nice_time_form
(1)含义
(2)例子
6、-c
(1)含义
(2)例子
7、-f
(1)含义
(2)例子
8、-v
(1)含义
(2)例子
9、-V
(1)含义
(2)例子
10、-E
(1)含义
(2)例子
11、-e
(1)含义
(2)例子
12、-s
(1)含义
(2)例子
13、-N
(1)含义
(2)例子
14、-H
(1)含义
(2)例子
15、-L
(1)含义
(2)例子
16、-p
(1)含义
(2)例子
一、测试环境
名称 | 值 |
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>