{"id":2436,"date":"2020-12-14T14:21:44","date_gmt":"2020-12-14T06:21:44","guid":{"rendered":"https:\/\/www.gbase8.cn\/?p=2436"},"modified":"2023-06-13T10:46:27","modified_gmt":"2023-06-13T02:46:27","slug":"gbase-8a%e7%9a%84show%e5%91%bd%e4%bb%a4%e5%88%97%e8%a1%a8%e5%92%8c%e4%bd%bf%e7%94%a8","status":"publish","type":"post","link":"https:\/\/www.gbase8.cn\/en\/2436","title":{"rendered":"\u5357\u5927\u901a\u7528GBase 8a\u7684show\u547d\u4ee4\u5217\u8868\u548c\u4f7f\u7528"},"content":{"rendered":"\n<p>GBase 8a\u63d0\u4f9b\u4e86show \u7ba1\u7406\u547d\u4ee4\uff0c\u6765\u67e5\u770b\u5404\u79cd\u6570\u636e\u5e93\u4fe1\u606f\uff0c\u672c\u6587\u53ea\u662f\u8bed\u6cd5\u7ea7\u7684\u7b80\u5355\u4ecb\u7ecd\u548c\u4e00\u4e9b\u4f7f\u7528\u6837\u4f8b\u3002<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_84 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">\u76ee\u5f55\u5bfc\u822a<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a2aea38ef2e9\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a2aea38ef2e9\"  aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.gbase8.cn\/en\/2436\/#%E9%80%9A%E7%94%A8%E8%AF%AD%E6%B3%95%E8%AF%B4%E6%98%8E\" >\u901a\u7528\u8bed\u6cd5\u8bf4\u660e<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.gbase8.cn\/en\/2436\/#full\" >full<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.gbase8.cn\/en\/2436\/#like\" >like<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.gbase8.cn\/en\/2436\/#where\" >where<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.gbase8.cn\/en\/2436\/#vc\" >vc<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.gbase8.cn\/en\/2436\/#database\" >database<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.gbase8.cn\/en\/2436\/#show_columns\" >show columns<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.gbase8.cn\/en\/2436\/#show_create\" >show create<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.gbase8.cn\/en\/2436\/#SHOW_CREATE_FUNCTION\" >SHOW CREATE FUNCTION<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/www.gbase8.cn\/en\/2436\/#SHOW_CREATE_PROCEDURE\" >SHOW CREATE PROCEDURE<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/www.gbase8.cn\/en\/2436\/#SHOW_CREATE_PUBLIC_SYNONYM\" >SHOW CREATE PUBLIC SYNONYM<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/www.gbase8.cn\/en\/2436\/#SHOW_CREATE_SYNONYM\" >SHOW CREATE SYNONYM<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/www.gbase8.cn\/en\/2436\/#SHOW_CREATE_VIEW\" >SHOW CREATE VIEW<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/www.gbase8.cn\/en\/2436\/#show_databases\" >show databases;<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/www.gbase8.cn\/en\/2436\/#show_distribution_tables\" >show distribution tables<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/www.gbase8.cn\/en\/2436\/#show_engines\" >show engines<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/www.gbase8.cn\/en\/2436\/#show_errors\" >show errors<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-18\" href=\"https:\/\/www.gbase8.cn\/en\/2436\/#show_fields\" >show fields<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-19\" href=\"https:\/\/www.gbase8.cn\/en\/2436\/#show_full_tables\" >show full tables<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-20\" href=\"https:\/\/www.gbase8.cn\/en\/2436\/#show_function_status\" >show function status<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-21\" href=\"https:\/\/www.gbase8.cn\/en\/2436\/#show_gcluster_entry\" >show gcluster entry<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-22\" href=\"https:\/\/www.gbase8.cn\/en\/2436\/#show_gcluster_nodes\" >show gcluster nodes<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-23\" href=\"https:\/\/www.gbase8.cn\/en\/2436\/#show_grants\" >show grants<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-24\" href=\"https:\/\/www.gbase8.cn\/en\/2436\/#show_indexs\" >show indexs<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-25\" href=\"https:\/\/www.gbase8.cn\/en\/2436\/#show_nodes\" >show nodes<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-26\" href=\"https:\/\/www.gbase8.cn\/en\/2436\/#show_open_tables\" >show open tables<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-27\" href=\"https:\/\/www.gbase8.cn\/en\/2436\/#SHOW_PRIORITIES\" >SHOW PRIORITIES<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-28\" href=\"https:\/\/www.gbase8.cn\/en\/2436\/#show_procedure_status\" >show procedure status<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-29\" href=\"https:\/\/www.gbase8.cn\/en\/2436\/#show_processlist\" >show processlist<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-30\" href=\"https:\/\/www.gbase8.cn\/en\/2436\/#show_schemas\" >show schemas<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-31\" href=\"https:\/\/www.gbase8.cn\/en\/2436\/#show_status\" >show status<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-32\" href=\"https:\/\/www.gbase8.cn\/en\/2436\/#show_table_locks\" >show table locks<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-33\" href=\"https:\/\/www.gbase8.cn\/en\/2436\/#show_table_status\" >show table status<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-34\" href=\"https:\/\/www.gbase8.cn\/en\/2436\/#show_tables\" >show tables<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-35\" href=\"https:\/\/www.gbase8.cn\/en\/2436\/#show_tablespaces\" >show tablespaces<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-36\" href=\"https:\/\/www.gbase8.cn\/en\/2436\/#show_vcs\" >show vcs<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-37\" href=\"https:\/\/www.gbase8.cn\/en\/2436\/#show_warnings\" >show warnings<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-38\" href=\"https:\/\/www.gbase8.cn\/en\/2436\/#show_views\" >show views<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E9%80%9A%E7%94%A8%E8%AF%AD%E6%B3%95%E8%AF%B4%E6%98%8E\"><\/span>\u901a\u7528\u8bed\u6cd5\u8bf4\u660e<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u6307\u4e00\u4e9b\u529f\u80fd\u7684\u53c2\u6570\uff0c\u6709\u76f8\u540c\u7684\u8bed\u6cd5\u7ed3\u6784\uff0c\u540e\u9762\u5c31\u4e0d\u6bcf\u4e2a\u90fd\u5355\u72ec\u5199\u4e00\u6b21\u4e86\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"full\"><\/span>full<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u663e\u793a\u66f4\u5b8c\u6574\u7684\u4fe1\u606f\u3002\u9ed8\u8ba4\u663e\u793a\u7684\u662f\u7cbe\u7b80\u7684\u6807\u51c6\u4fe1\u606f\uff0cfull\u663e\u793a\u7684\u5217\u66f4\u591a\u4e00\u4e9b\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"like\"><\/span>like<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u652f\u6301\u6a21\u7cca\u5339\u914d\u7684\u90e8\u5206\uff0c\u6bd4\u5982\u8868\u540d\uff0c\u5217\u540d\u7b49\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"where\"><\/span>where<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u5c5e\u4e8elike\u7684\u589e\u5f3a\uff0c\u4e0d\u5355\u5355\u662f\u540d\u5b57\uff0c\u8fd8\u53ef\u4ee5\u5bf9\u8fd4\u56de\u4fe1\u606f\u7684\u591a\u4e2a\u5217\u8fdb\u884cSQL\u7ea7\u522b\u7684\u7ec4\u5408\u8fc7\u6ee4\u3002\u9700\u8981\u6ce8\u610f\u7684\u662f\uff0c\u5217\u540d\u5b57\u6709\u65f6\u662f\u5173\u952e\u5b57\uff0c\u5efa\u8bae\u7528\u6813\u5f15\u53f7\u5305\u56f4\u8d77\u6765\uff0c\u6bd4\u5982<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>where \"table_name\" like '%abcd%'<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"vc\"><\/span>vc<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u5bf9\u5e94V95\u7248\u672c\u5f00\u59cb\u652f\u6301\u7684\u865a\u62df\u96c6\u7fa4\uff1b<br>1\u3001V8\u6ca1\u6709\u8fd9\u90e8\u5206<br>2\u3001\u5982\u679cV9\u6ca1\u6709\u542f\u7528\u865a\u62df\u96c6\u7fa4\uff0c\u8fd9\u90e8\u5206\u4e5f\u53ef\u4ee5\u5ffd\u7565<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"database\"><\/span>database<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u6570\u636e\u5e93\u540d\u3002\u5982\u679c\u4e0d\u6307\u5b9a\u5219\u9ed8\u8ba4\u662f\u5f53\u524d\u6570\u636e\u5e93\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"columns\"><span class=\"ez-toc-section\" id=\"show_columns\"><\/span>show columns<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u663e\u793a\u6307\u5b9a\u8868\u7684\u5217\u4fe1\u606f<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>gbase&gt; show columns from t2;\n+-------+-------------+------+-----+---------+-------+\n| Field | Type        | Null | Key | Default | Extra |\n+-------+-------------+------+-----+---------+-------+\n| v1    | varchar(10) | YES  |     | NULL    |       |\n| v2    | varchar(10) | YES  |     | NULL    |       |\n| v3    | varchar(10) | YES  |     | NULL    |       |\n| v4    | varchar(10) | YES  |     | NULL    |       |\n+-------+-------------+------+-----+---------+-------+\n4 rows in set (Elapsed: 00:00:00.00)\n\ngbase&gt; show columns from t2 from testdb;\n+-------+-------------+------+-----+---------+-------+\n| Field | Type        | Null | Key | Default | Extra |\n+-------+-------------+------+-----+---------+-------+\n| v1    | varchar(10) | YES  |     | NULL    |       |\n| v2    | varchar(10) | YES  |     | NULL    |       |\n| v3    | varchar(10) | YES  |     | NULL    |       |\n| v4    | varchar(10) | YES  |     | NULL    |       |\n+-------+-------------+------+-----+---------+-------+\n4 rows in set (Elapsed: 00:00:00.00)\n\n\ngbase&gt; show columns from t2 like '%1%';\n+-------+-------------+------+-----+---------+-------+\n| Field | Type        | Null | Key | Default | Extra |\n+-------+-------------+------+-----+---------+-------+\n| v1    | varchar(10) | YES  |     | NULL    |       |\n+-------+-------------+------+-----+---------+-------+\n1 row in set (Elapsed: 00:00:00.00)\n\n\ngbase&gt; show full columns from testdb.t2 where type like '%varchar%' and \"key\"='';\n+-------+-------------+-----------------+------+-----+---------+-------+---------------------------------+---------+\n| Field | Type        | Collation       | Null | Key | Default | Extra | Privileges                      | Comment |\n+-------+-------------+-----------------+------+-----+---------+-------+---------------------------------+---------+\n| v1    | varchar(10) | utf8_general_ci | YES  |     | NULL    |       | select,insert,update,references |         |\n| v2    | varchar(10) | utf8_general_ci | YES  |     | NULL    |       | select,insert,update,references |         |\n| v3    | varchar(10) | utf8_general_ci | YES  |     | NULL    |       | select,insert,update,references |         |\n| v4    | varchar(10) | utf8_general_ci | YES  |     | NULL    |       | select,insert,update,references |         |\n+-------+-------------+-----------------+------+-----+---------+-------+---------------------------------+---------+\n4 rows in set (Elapsed: 00:00:00.00)\n\ngbase&gt;\n\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"show_create\"><\/span>show create<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u663e\u793a\u5bf9\u8c61\u7684\u521b\u5efa\u8bed\u53e5\u3002\u683c\u5f0f\u5168\u90e8\u662f<\/p>\n\n\n\n<p>show create OBJECT_TYPE objectName<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"SHOW_CREATE_FUNCTION\"><\/span>SHOW CREATE FUNCTION<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u81ea\u5b9a\u4e49\u51fd\u6570\u7684\u521b\u5efa\u8bed\u53e5<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"SHOW_CREATE_PROCEDURE\"><\/span>SHOW CREATE PROCEDURE<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u5b58\u50a8\u8fc7\u7a0b\u521b\u5efa\u8bed\u53e5<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"SHOW_CREATE_PUBLIC_SYNONYM\"><\/span>SHOW CREATE PUBLIC SYNONYM<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u5149\u6709\u7684\u540c\u4e49\u8bcd\u521b\u5efa\u8bed\u53e5<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"SHOW_CREATE_SYNONYM\"><\/span>SHOW CREATE SYNONYM<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u79c1\u6709\u7684\u540c\u4e49\u8bcd\u521b\u5efa\u8bed\u53e5<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"SHOW_CREATE_VIEW\"><\/span>SHOW CREATE VIEW<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u89c6\u56fe\u521b\u5efa\u8bed\u53e5\u3002<\/p>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"databases\"><span class=\"ez-toc-section\" id=\"show_databases\"><\/span>show databases;<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u663e\u793aGBase\u91cc\uff0c\u5f53\u524d\u7528\u6237\u80fd\u8bbf\u95ee\u7684\u6570\u636e\u5e93\uff0c\u6709\u54ea\u4e9b\u5e93\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>gbase&gt; show databases;\n+--------------------+\n| Database           |\n+--------------------+\n| information_schema |\n| performance_schema |\n| abc                |\n| db1                |\n| db2                |\n| dbmain             |\n| gbase              |\n| gclusterdb         |\n| gctmpdb            |\n| test               |\n| testdb             |\n+--------------------+\n11 rows in set (Elapsed: 00:00:00.00)\n\ngbase&gt; show databases like '%db%';\n+-----------------+\n| Database (%db%) |\n+-----------------+\n| db1             |\n| db2             |\n| dbmain          |\n| gclusterdb      |\n| gctmpdb         |\n| testdb          |\n+-----------------+\n6 rows in set (Elapsed: 00:00:00.00)\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"show_distribution_tables\"><\/span>show distribution tables<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u663e\u793aexpress\u8868\u7684\u5217\u8868\uff0c\u5305\u62ec\u5206\u5e03\u8868\u548c\u590d\u5236\u8868\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>\ngbase&gt; create table db1_t2_rep(id int)replicated;\nQuery OK, 0 rows affected (Elapsed: 00:00:01.27)\n\ngbase&gt; show distribution tables;\n+--------+------------+-------------+\n| dbName | tbName     | isReplicate |\n+--------+------------+-------------+\n| db1    | db1_t2_rep | YES         |\n| db1    | db1_t1     | NO          |\n+--------+------------+-------------+\n2 rows in set (Elapsed: 00:00:00.00)\n\ngbase&gt; show distribution tables like '%1%';\n+--------+------------+-------------+\n| dbName | tbName     | isReplicate |\n+--------+------------+-------------+\n| db1    | db1_t2_rep | YES         |\n| db1    | db1_t1     | NO          |\n+--------+------------+-------------+\n2 rows in set (Elapsed: 00:00:00.00)\n\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"show_engines\"><\/span>show engines<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>gbase&gt; show engines;\n+-----------+---------+-----------------------------------------------------------+--------------+------+------------+\n| Engine    | Support | Comment                                                   | Transactions | XA   | Savepoints |\n+-----------+---------+-----------------------------------------------------------+--------------+------+------------+\n| MRG_GSSYS | YES     | Collection of identical GsSYS tables                      | NO           | NO   | NO         |\n| CSV       | YES     | CSV storage engine                                        | NO           | NO   | NO         |\n| EXPRESS   | DEFAULT | Express storage engine                                    | YES          | YES  | NO         |\n| GsSYS     | YES     | GsSYS engine                                              | NO           | NO   | NO         |\n| MEMORY    | YES     | Hash based, stored in memory, useful for temporary tables | NO           | NO   | NO         |\n+-----------+---------+-----------------------------------------------------------+--------------+------+------------+\n5 rows in set (Elapsed: 00:00:00.00)\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"show_errors\"><\/span>show errors<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u663e\u793a\u9519\u8bef\u4fe1\u606f<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>gbase&gt; show errors;\nEmpty set (Elapsed: 00:00:00.00)\n\ngbase&gt; show errors limit 3,1;\nEmpty set (Elapsed: 00:00:00.00)\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"show_fields\"><\/span>show fields<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u4e0e<a href=\"#columns\">show columns<\/a>\u4e00\u6837\uff0c\u522b\u540d\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"show_full_tables\"><\/span>show full tables<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u5305\u542b\u8868\u7c7b\u578b\uff0c \u89c6\u56fe\u662fVIEW, \u8868\u662fBASE TABLE<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>gbase> show full tables;\r\n+------------------+------------+\r\n| Tables_in_testdb | Table_type |\r\n+------------------+------------+\r\n| hash             | BASE TABLE |\r\n| nodedatamap      | BASE TABLE |\r\n| t                | BASE TABLE |\r\n| t1               | BASE TABLE |\r\n| t2               | BASE TABLE |\r\n| t3               | BASE TABLE |\r\n| t4               | BASE TABLE |\r\n| tdecimal         | BASE TABLE |\r\n| tdecimal2        | BASE TABLE |\r\n| thash            | BASE TABLE |\r\n| tlike            | BASE TABLE |\r\n| tlike2           | BASE TABLE |\r\n| tmp_nodedatamap  | BASE TABLE |\r\n| tr               | BASE TABLE |\r\n| tsi              | BASE TABLE |\r\n| tt               | BASE TABLE |\r\n| tti              | BASE TABLE |\r\n| ttt              | BASE TABLE |\r\n| v_tr             | VIEW       |\r\n+------------------+------------+\r\n19 rows in set (Elapsed: 00:00:00.00)\r\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"show_function_status\"><\/span>show function status<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u663e\u793a\u81ea\u5b9a\u4e49\u51fd\u6570\u7684\u5217\u8868\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>gbase&gt; delimiter \/\/\ngbase&gt; create function f_now() returns datetime begin return now();end \/\/\nQuery OK, 0 rows affected (Elapsed: 00:00:00.02)\n\ngbase&gt; delimiter ;\ngbase&gt; select f_now();\n+---------------------+\n| f_now()             |\n+---------------------+\n| 2020-12-14 14:54:43 |\n+---------------------+\n1 row in set (Elapsed: 00:00:00.00)\n\ngbase&gt; show function status;\n+------------------------------------------------------------------+------------------------------------------------------------------+----------+-------------------------------------------------------------------------------+---------------------+---------------------+---------------+------------------------------------------------------------------+----------------------------------+----------------------------------+----------------------------------+\n| Db                                                               | Name                                                             | Type     | Definer                                                                       | Modified            | Created             | Security_type | Comment                                                          | character_set_client             | collation_connection             | Database Collation               |\n+------------------------------------------------------------------+------------------------------------------------------------------+----------+-------------------------------------------------------------------------------+---------------------+---------------------+---------------+------------------------------------------------------------------+----------------------------------+----------------------------------+----------------------------------+\n| db1                                                              | f_now                                                            | FUNCTION | root@%                                                                        | 2020-12-14 14:54:26 | 2020-12-14 14:54:26 | DEFINER       |                                                                  | utf8                             | utf8_general_ci                  | utf8_general_ci                  |\n| testdb                                                           | gcadmin                                                          | FUNCTION | root@%                                                                        | 2020-11-19 10:19:34 | 2020-11-19 10:19:34 | DEFINER       |                                                                  | utf8                             | utf8_general_ci                  | utf8_general_ci                  |\n+------------------------------------------------------------------+------------------------------------------------------------------+----------+-------------------------------------------------------------------------------+---------------------+---------------------+---------------+------------------------------------------------------------------+----------------------------------+----------------------------------+----------------------------------+\n2 rows in set (Elapsed: 00:00:00.00)\n\ngbase&gt; show function status from db1;\nERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your GBase server version for the right syntax to use near 'from db1' at line 1\ngbase&gt; show function status where db='db1';\n+------------------------------------------------------------------+------------------------------------------------------------------+----------+-------------------------------------------------------------------------------+---------------------+---------------------+---------------+------------------------------------------------------------------+----------------------------------+----------------------------------+----------------------------------+\n| Db                                                               | Name                                                             | Type     | Definer                                                                       | Modified            | Created             | Security_type | Comment                                                          | character_set_client             | collation_connection             | Database Collation               |\n+------------------------------------------------------------------+------------------------------------------------------------------+----------+-------------------------------------------------------------------------------+---------------------+---------------------+---------------+------------------------------------------------------------------+----------------------------------+----------------------------------+----------------------------------+\n| db1                                                              | f_now                                                            | FUNCTION | root@%                                                                        | 2020-12-14 14:54:26 | 2020-12-14 14:54:26 | DEFINER       |                                                                  | utf8                             | utf8_general_ci                  | utf8_general_ci                  |\n+------------------------------------------------------------------+------------------------------------------------------------------+----------+-------------------------------------------------------------------------------+---------------------+---------------------+---------------+------------------------------------------------------------------+----------------------------------+----------------------------------+----------------------------------+\n1 row in set (Elapsed: 00:00:00.00)\n\ngbase&gt;\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"show_gcluster_entry\"><\/span>show gcluster entry<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u663e\u793a\u8fde\u63a5\u6570\u6700\u5c11\u7684\u8282\u70b9\u4fe1\u606f\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; show gcluster entry;\n+------------+------+\n| IP         | Port |\n+------------+------+\n| 10.0.2.201 | 5258 |\n+------------+------+\n1 row in set (Elapsed: 00:00:00.00)\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"show_gcluster_nodes\"><\/span>show gcluster nodes<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u83b7\u5f97\u96c6\u7fa4\u6240\u6709\u8c03\u5ea6\/\u7ba1\u7406cooridinator\u8282\u70b9<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>gbase> show gcluster nodes;\r\n+------------+------------+--------------+--------+-----------+\r\n| Id         | ip         | name         | status | datastate |\r\n+------------+------------+--------------+--------+-----------+\r\n| 1694629898 | 10.0.2.101 | coordinator1 | online |         0 |\r\n+------------+------------+--------------+--------+-----------+\r\n1 row in set (Elapsed: 00:00:00.00)\r\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"show_grants\"><\/span>show grants<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u663e\u793a\u7528\u6237\u7684\u6388\u6743\u60c5\u51b5\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>gbase&gt; show grants;\n+-----------------------------------------------------------------------------+\n| Grants for root@%                                                           |\n+-----------------------------------------------------------------------------+\n| GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION TASK_PRIORITY 2 |\n+-----------------------------------------------------------------------------+\n1 row in set (Elapsed: 00:00:00.00)\n\ngbase&gt; show grants for abc;\n+-------------------------------------------------------------------------------------------------------------------------+\n| Grants for abc@%                                                                                                        |\n+-------------------------------------------------------------------------------------------------------------------------+\n| GRANT USAGE ON *.* TO 'abc'@'%' IDENTIFIED BY PASSWORD '*0D3CED9BEC10A777AEC23CCC353A8C08A633045E' WITH TASK_PRIORITY 2 |\n| GRANT ALL PRIVILEGES ON \"abc\".* TO 'abc'@'%'                                                                            |\n| GRANT ALL PRIVILEGES ON \"testdb\".* TO 'abc'@'%'                                                                         |\n+-------------------------------------------------------------------------------------------------------------------------+\n3 rows in set (Elapsed: 00:00:00.00)\n\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"show_indexs\"><\/span>show indexs<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u67e5\u770b\u7d22\u5f15\u3002\u76ee\u524dexpress\u8868\u53ea\u6709global hash\u7d22\u5f15\u548cgrouped\u7684\u884c\u5b58\u5217\u4e24\u79cd\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>gbase&gt; create index idx_v2 on t2(v2) key_block_size=4096 using hash global;\nQuery OK, 0 rows affected (Elapsed: 00:00:01.05)\nRecords: 0  Duplicates: 0  Warnings: 0\n\ngbase&gt; alter table t2 add grouped grp_234(v2,v3,v4);\nQuery OK, 1 row affected (Elapsed: 00:00:00.51)\nRecords: 1  Duplicates: 1  Warnings: 0\n\ngbase&gt; show index from testdb.t2;\n+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+-------------+---------+\n| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type  | Comment |\n+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+-------------+---------+\n| t2    |          1 | idx_v2   |            1 | v2          | NULL      |        NULL |     NULL | NULL   | YES  | GLOBAL HASH |         |\n| t2    |          1 | grp_234  |            1 | v2          | NULL      |        NULL |     NULL | NULL   | YES  | GROUPED     |         |\n| t2    |          1 | grp_234  |            2 | v3          | NULL      |        NULL |     NULL | NULL   | YES  | GROUPED     |         |\n| t2    |          1 | grp_234  |            3 | v4          | NULL      |        NULL |     NULL | NULL   | YES  | GROUPED     |         |\n+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+-------------+---------+\n4 rows in set (Elapsed: 00:00:00.00)\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"show_nodes\"><\/span>show nodes<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u663e\u793a\u8ba1\u7b97\u8282\u70b9\u7684\u4fe1\u606f\uff1b<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>gbase&gt; show nodes;\n+------------+------------+-------+--------------+----------------+--------+-----------+\n| Id         | ip         | name  | primary part | duplicate part | status | datastate |\n+------------+------------+-------+--------------+----------------+--------+-----------+\n| 3389128714 | 10.0.2.202 | node2 | n1           | n2             | online |         0 |\n| 3372351498 | 10.0.2.201 | node1 | n2           | n1             | online |         0 |\n+------------+------------+-------+--------------+----------------+--------+-----------+\n2 rows in set (Elapsed: 00:00:00.00)\n\ngbase&gt; show gcluster nodes;\n+------------+------------+--------------+--------+-----------+\n| Id         | ip         | name         | status | datastate |\n+------------+------------+--------------+--------+-----------+\n| 3372351498 | 10.0.2.201 | coordinator1 | online |         0 |\n+------------+------------+--------------+--------+-----------+\n1 row in set (Elapsed: 00:00:00.00)\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"show_open_tables\"><\/span>show open tables<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>gbase&gt; show open tables;\n+------------+-------------------+--------+-------------+\n| Database   | Table             | In_use | Name_locked |\n+------------+-------------------+--------+-------------+\n| testdb     | t1                |      0 |           0 |\n| testdb     | t2                |      0 |           0 |\n| gbase      | event             |      0 |           0 |\n| gclusterdb | audit_log_express |      0 |           0 |\n+------------+-------------------+--------+-------------+\n4 rows in set (Elapsed: 00:00:00.00)\ngbase&gt; show open tables from testdb;\n+----------+-------+--------+-------------+\n| Database | Table | In_use | Name_locked |\n+----------+-------+--------+-------------+\n| testdb   | t1    |      0 |           0 |\n| testdb   | t2    |      0 |           0 |\n+----------+-------+--------+-------------+\n2 rows in set (Elapsed: 00:00:00.00)\n\ngbase&gt; show open tables from testdb where \"table\" like '%1%' and in_use=0;\n+----------+-------+--------+-------------+\n| Database | Table | In_use | Name_locked |\n+----------+-------+--------+-------------+\n| testdb   | t1    |      0 |           0 |\n+----------+-------+--------+-------------+\n1 row in set (Elapsed: 00:00:00.00)\n\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"SHOW_PRIORITIES\"><\/span>SHOW PRIORITIES<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u663e\u793a\u8d44\u6e90\u7ba1\u63a7\u7684\u5f53\u524d\u9ed8\u8ba4\u4f18\u5148\u7ea7\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>gbase&gt; SHOW PRIORITIES ;\n+-----------+-------+----------+-----------------+--------+------------------------------------------------------------------------------------------------------------------------+\n| node_name | group | priority | priority_weight | status | description                                                                                                            |\n+-----------+-------+----------+-----------------+--------+------------------------------------------------------------------------------------------------------------------------+\n| node1     |     0 |        0 |              20 | OFF    | control group path: \"gbase\/gbase\/ugroup0\/upriority0 \"   parameters:  \" cpuset=  memset=  cpu_shares=  blkio_weight= \"  |\n| node1     |     0 |        1 |              40 | OFF    | control group path: \"gbase\/gbase\/ugroup0\/upriority1 \"   parameters:  \" cpuset=  memset=  cpu_shares=  blkio_weight= \"  |\n| node1     |     0 |        2 |              60 | OFF    | control group path: \"gbase\/gbase\/ugroup0\/upriority2 \"   parameters:  \" cpuset=  memset=  cpu_shares=  blkio_weight= \"  |\n| node1     |     0 |        3 |              80 | OFF    | control group path: \"gbase\/gbase\/ugroup0\/upriority3 \"   parameters:  \" cpuset=  memset=  cpu_shares=  blkio_weight= \"  |\n\n........... \u5ffd\u7565\n\n| node2     |    15 |        2 |              60 | OFF    | control group path: \"gbase\/gbase\/ugroup15\/upriority2 \"   parameters:  \" cpuset=  memset=  cpu_shares=  blkio_weight= \" |\n| node2     |    15 |        3 |              80 | OFF    | control group path: \"gbase\/gbase\/ugroup15\/upriority3 \"   parameters:  \" cpuset=  memset=  cpu_shares=  blkio_weight= \" |\n+-----------+-------+----------+-----------------+--------+------------------------------------------------------------------------------------------------------------------------+\n128 rows in set (Elapsed: 00:00:00.00)\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"show_procedure_status\"><\/span>show procedure status<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u663e\u793a\u81ea\u5b9a\u4e49\u5b58\u50a8\u8fc7\u7a0b\u7684\u5217\u8868\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>gbase&gt; delimiter \/\/\ngbase&gt; create procedure p_now() begin select now(); end;\/\/\nQuery OK, 0 rows affected (Elapsed: 00:00:00.00)\n\ngbase&gt; delimiter ;\ngbase&gt; call p_now();\n+---------------------+\n| now()               |\n+---------------------+\n| 2020-12-14 14:58:13 |\n+---------------------+\n1 row in set (Elapsed: 00:00:00.01)\n\nQuery OK, 0 rows affected (Elapsed: 00:00:00.01)\n\ngbase&gt; show procedure status;\n+------------------------------------------------------------------+------------------------------------------------------------------+-----------+-------------------------------------------------------------------------------+---------------------+---------------------+---------------+------------------------------------------------------------------+----------------------------------+----------------------------------+----------------------------------+\n| Db                                                               | Name                                                             | Type      | Definer                                                                       | Modified            | Created             | Security_type | Comment                                                          | character_set_client             | collation_connection             | Database Collation               |\n+------------------------------------------------------------------+------------------------------------------------------------------+-----------+-------------------------------------------------------------------------------+---------------------+---------------------+---------------+------------------------------------------------------------------+----------------------------------+----------------------------------+----------------------------------+\n| db1                                                              | p_now                                                            | PROCEDURE | root@%                                                                        | 2020-12-14 14:58:05 | 2020-12-14 14:58:05 | DEFINER       |                                                                  | utf8                             | utf8_general_ci                  | utf8_general_ci                  |\n+------------------------------------------------------------------+------------------------------------------------------------------+-----------+-------------------------------------------------------------------------------+---------------------+---------------------+---------------+------------------------------------------------------------------+----------------------------------+----------------------------------+----------------------------------+\n1 row in set (Elapsed: 00:00:00.00)\n\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"show_processlist\"><\/span>show processlist<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u663e\u793a\u8fdb\u7a0b\u4fe1\u606f\u3002\u8bf7\u53c2\u8003 <a href=\"https:\/\/www.gbase8.cn\/65\">GBase8a \u663e\u793a\u96c6\u7fa4\u6b63\u5728\u8dd1\u7684SQL\u8fdb\u7a0bshow [full | detail] processlist<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"show_schemas\"><\/span>show schemas<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u548c <a href=\"#databases\">show database<\/a>s\u5b8c\u5168\u76f8\u540c\uff0c\u663e\u793a\u6570\u636e\u5e93\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"show_status\"><\/span>show status<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u663e\u793a\u8fd0\u884c\u72b6\u6001\u4fe1\u606f\u3002\u53c2\u8003 <a href=\"https:\/\/www.gbase8.cn\/108\">GBase 8a\u96c6\u7fa4\u67e5\u770b\u5f53\u524d\u8fd0\u884c\u72b6\u6001\uff0c\u5185\u5b58\u4f7f\u7528\u60c5\u51b5<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"show_table_locks\"><\/span>show table locks<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u663e\u793a\u8868\u7684\u8282\u70b9\u9501\u4f7f\u7528\u60c5\u51b5\u3002\u7528\u4e8e\u5728\u8ba1\u7b97\u8282\u70b9gnode\u67e5\u770b\u9501\u3002<\/p>\n\n\n\n<p>\u53c2\u8003 <a href=\"https:\/\/www.gbase8.cn\/148\">GBase 8a\u96c6\u7fa4\u67e5\u770bgnode\u8ba1\u7b97\u8282\u70b9\u67d0\u5f20\u8868\u7684\u9501<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"show_table_status\"><\/span>show table status<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u663e\u793a\u8868\u7684\u5f53\u524d\u8be6\u7ec6\u72b6\u6001\uff0c\u5305\u62ec\u78c1\u76d8\u5360\u7528\u7b49\u3002\u6570\u636e\u6765\u6e90\u4e8einformation_schema.tables\u7684\u5143\u6570\u636e\u8868\u3002<\/p>\n\n\n\n<p>\u63d0\u793a\uff1a\u5982\u679c\u8868\u5f88\u591a\uff0c\u6bd4\u5982\u51e0\u4e07\u4ee5\u4e0a\uff0c\u4e0d\u5efa\u8bae\u4e0d\u5e26\u6761\u4ef6\uff0c\u907f\u514d\u78c1\u76d8\u5927\u91cf\u968f\u673a\u8bfb\u53d6\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>gbase&gt; use db1;\nQuery OK, 0 rows affected (Elapsed: 00:00:00.00)\n\ngbase&gt;\ngbase&gt; show table status;\n+-------------------+---------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-----------------+----------+------------------+--------------------+--------------+-----------------+---------+----------------------------+-----------------------------+\n| Name              | Engine  | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time         | Update_time         | Check_time | Collation       | Checksum | Create_options   | Limit_storage_size | storage_size | table_data_size | Comment | local_hash_index_file_size | global_hash_index_file_size |\n+-------------------+---------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-----------------+----------+------------------+--------------------+--------------+-----------------+---------+----------------------------+-----------------------------+\n| db1_t1            | EXPRESS |      10 | Compressed |    0 |              0 |           0 |               0 |            0 |         0 |           NULL | 2020-12-14 08:28:45 | 2020-12-14 08:28:45 | NULL       | utf8_general_ci |     NULL | avg_row_length=5 |                  0 |          414 |               0 |         |                          0 |                           0 |\n| v_t1              | NULL    |    NULL | NULL       | NULL |           NULL |        NULL |            NULL |         NULL |      NULL |           NULL | NULL                | NULL                | NULL       | NULL            |     NULL | NULL             |               NULL |         NULL |            NULL | VIEW    |                       NULL |                        NULL |\n| v_t1_178291728712 | NULL    |    NULL | NULL       | NULL |           NULL |        NULL |            NULL |         NULL |      NULL |           NULL | NULL                | NULL                | NULL       | NULL            |     NULL | NULL             |               NULL |         NULL |            NULL | VIEW    |                       NULL |                        NULL |\n+-------------------+---------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-----------------+----------+------------------+--------------------+--------------+-----------------+---------+----------------------------+-----------------------------+\n3 rows in set (Elapsed: 00:00:00.00)\n\ngbase&gt; show table status from db1;\n+-------------------+---------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-----------------+----------+------------------+--------------------+--------------+-----------------+---------+----------------------------+-----------------------------+\n| Name              | Engine  | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time         | Update_time         | Check_time | Collation       | Checksum | Create_options   | Limit_storage_size | storage_size | table_data_size | Comment | local_hash_index_file_size | global_hash_index_file_size |\n+-------------------+---------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-----------------+----------+------------------+--------------------+--------------+-----------------+---------+----------------------------+-----------------------------+\n| db1_t1            | EXPRESS |      10 | Compressed |    0 |              0 |           0 |               0 |            0 |         0 |           NULL | 2020-12-14 08:28:45 | 2020-12-14 08:28:45 | NULL       | utf8_general_ci |     NULL | avg_row_length=5 |                  0 |          414 |               0 |         |                          0 |                           0 |\n| v_t1              | NULL    |    NULL | NULL       | NULL |           NULL |        NULL |            NULL |         NULL |      NULL |           NULL | NULL                | NULL                | NULL       | NULL            |     NULL | NULL             |               NULL |         NULL |            NULL | VIEW    |                       NULL |                        NULL |\n| v_t1_178291728712 | NULL    |    NULL | NULL       | NULL |           NULL |        NULL |            NULL |         NULL |      NULL |           NULL | NULL                | NULL                | NULL       | NULL            |     NULL | NULL             |               NULL |         NULL |            NULL | VIEW    |                       NULL |                        NULL |\n+-------------------+---------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-----------------+----------+------------------+--------------------+--------------+-----------------+---------+----------------------------+-----------------------------+\n3 rows in set (Elapsed: 00:00:00.01)\n\ngbase&gt; show table status from db1 like '%1%';\n+-------------------+---------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-----------------+----------+------------------+--------------------+--------------+-----------------+---------+----------------------------+-----------------------------+\n| Name              | Engine  | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time         | Update_time         | Check_time | Collation       | Checksum | Create_options   | Limit_storage_size | storage_size | table_data_size | Comment | local_hash_index_file_size | global_hash_index_file_size |\n+-------------------+---------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-----------------+----------+------------------+--------------------+--------------+-----------------+---------+----------------------------+-----------------------------+\n| db1_t1            | EXPRESS |      10 | Compressed |    0 |              0 |           0 |               0 |            0 |         0 |           NULL | 2020-12-14 08:28:45 | 2020-12-14 08:28:45 | NULL       | utf8_general_ci |     NULL | avg_row_length=5 |                  0 |          414 |               0 |         |                          0 |                           0 |\n| v_t1              | NULL    |    NULL | NULL       | NULL |           NULL |        NULL |            NULL |         NULL |      NULL |           NULL | NULL                | NULL                | NULL       | NULL            |     NULL | NULL             |               NULL |         NULL |            NULL | VIEW    |                       NULL |                        NULL |\n| v_t1_178291728712 | NULL    |    NULL | NULL       | NULL |           NULL |        NULL |            NULL |         NULL |      NULL |           NULL | NULL                | NULL                | NULL       | NULL            |     NULL | NULL             |               NULL |         NULL |            NULL | VIEW    |                       NULL |                        NULL |\n+-------------------+---------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-----------------+----------+------------------+--------------------+--------------+-----------------+---------+----------------------------+-----------------------------+\n3 rows in set (Elapsed: 00:00:00.00)\n\ngbase&gt; show table status from db1 where name like '%1%' and comment='VIEW';\n+-------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+-----------+----------+----------------+--------------------+--------------+-----------------+---------+----------------------------+-----------------------------+\n| Name              | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Limit_storage_size | storage_size | table_data_size | Comment | local_hash_index_file_size | global_hash_index_file_size |\n+-------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+-----------+----------+----------------+--------------------+--------------+-----------------+---------+----------------------------+-----------------------------+\n| v_t1              | NULL   |    NULL | NULL       | NULL |           NULL |        NULL |            NULL |         NULL |      NULL |           NULL | NULL        | NULL        | NULL       | NULL      |     NULL | NULL           |               NULL |         NULL |            NULL | VIEW    |                       NULL |                        NULL |\n| v_t1_178291728712 | NULL   |    NULL | NULL       | NULL |           NULL |        NULL |            NULL |         NULL |      NULL |           NULL | NULL        | NULL        | NULL       | NULL      |     NULL | NULL           |               NULL |         NULL |            NULL | VIEW    |                       NULL |                        NULL |\n+-------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+-----------+----------+----------------+--------------------+--------------+-----------------+---------+----------------------------+-----------------------------+\n2 rows in set (Elapsed: 00:00:00.00)\n<\/code><\/pre>\n\n\n\n<p>\u67e5\u770b\u67d0\u4e2a\u8868\u7684\u5f53\u524d\u72b6\u6001<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; show table status where name='t1'\\G;\n*************************** 1. row ***************************\n                       Name: t1\n                     Engine: EXPRESS\n                    Version: 10\n                 Row_format: Compressed\n                       Rows: 0\n             Avg_row_length: 0\n                Data_length: 0\n            Max_data_length: 0\n               Index_length: 0\n                  Data_free: 0\n             Auto_increment: NULL\n                Create_time: 2021-01-25 09:44:04\n                Update_time: NULL\n                 Check_time: NULL\n                  Collation: utf8_general_ci\n                   Checksum: NULL\n             Create_options: avg_row_length=5\n         Limit_storage_size: 0\n               storage_size: 285\n            table_data_size: 0\n                    Comment:\n local_hash_index_file_size: 0\nglobal_hash_index_file_size: 0\n            tablespace_name: NULL\n            tablespace_path: NULL\n1 row in set (Elapsed: 00:00:00.00)\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"show_tables\"><\/span>show tables<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u67e5\u770b\u8868\u540d\u5b57\u3002 \u5305\u62ec show full tables<\/p>\n\n\n\n<p>\u63d0\u793a\uff1a\u5982\u679c\u8868\u5f88\u591a\uff0c\u6bd4\u5982\u51e0\u4e07\u4ee5\u4e0a\uff0c\u4e0d\u5efa\u8bae\u4e0d\u5e26\u6761\u4ef6\uff0c\u907f\u514d\u78c1\u76d8\u5927\u91cf\u968f\u673a\u8bfb\u53d6\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>gbase&gt; use db1;\nQuery OK, 0 rows affected (Elapsed: 00:00:00.00)\n\ngbase&gt; show tables;\n+-------------------+\n| Tables_in_db1     |\n+-------------------+\n| db1_t1            |\n| v_t1              |\n| v_t1_178291728712 |\n+-------------------+\n3 rows in set (Elapsed: 00:00:00.00)\n\ngbase&gt; show full tables;\n+-------------------+------------+\n| Tables_in_db1     | Table_type |\n+-------------------+------------+\n| db1_t1            | BASE TABLE |\n| v_t1              | VIEW       |\n| v_t1_178291728712 | VIEW       |\n+-------------------+------------+\n3 rows in set (Elapsed: 00:00:00.00)\n\ngbase&gt; show full tables like '%t1%';\n+----------------------+------------+\n| Tables_in_db1 (%t1%) | Table_type |\n+----------------------+------------+\n| db1_t1               | BASE TABLE |\n| v_t1                 | VIEW       |\n| v_t1_178291728712    | VIEW       |\n+----------------------+------------+\n3 rows in set (Elapsed: 00:00:00.00)\n\ngbase&gt; show full tables where tables_in_db1 like '%t1%';\n+-------------------+------------+\n| Tables_in_db1     | Table_type |\n+-------------------+------------+\n| db1_t1            | BASE TABLE |\n| v_t1              | VIEW       |\n| v_t1_178291728712 | VIEW       |\n+-------------------+------------+\n3 rows in set (Elapsed: 00:00:00.00)\n\ngbase&gt; show full tables where tables_in_db1 like '%t1%' and table_type='VIEW';\n+-------------------+------------+\n| Tables_in_db1     | Table_type |\n+-------------------+------------+\n| v_t1              | VIEW       |\n| v_t1_178291728712 | VIEW       |\n+-------------------+------------+\n2 rows in set (Elapsed: 00:00:00.00)\n\ngbase&gt; show full tables where tables_in_db1 like '%t1%' and table_type='view';\n+-------------------+------------+\n| Tables_in_db1     | Table_type |\n+-------------------+------------+\n| v_t1              | VIEW       |\n| v_t1_178291728712 | VIEW       |\n+-------------------+------------+\n2 rows in set (Elapsed: 00:00:00.00)\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"show_tablespaces\"><\/span>show tablespaces<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u67e5\u770b\u8868\u7a7a\u95f4\uff0c\u4eceV95\u7248\u672c\u624d\u652f\u6301\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; use testdb;\nQuery OK, 0 rows affected (Elapsed: 00:00:00.01)\n\ngbase&gt; show tablespaces;\n+----------------------+\n| Tablespace_in_testdb |\n+----------------------+\n| sys_tablespace       |\n+----------------------+\n1 row in set (Elapsed: 00:00:00.00)\n\n\ngbase&gt; create tablespace tablespace_ssd datadir '\/opt\/gbase\/ssd';\nQuery OK, 0 rows affected (Elapsed: 00:00:00.01)\n\ngbase&gt; show tablespaces;\n+----------------------+\n| Tablespace_in_testdb |\n+----------------------+\n| sys_tablespace       |\n| tablespace_ssd       |\n+----------------------+\n2 rows in set (Elapsed: 00:00:00.00)\n<\/code><\/pre>\n\n\n\n<p>show variables<\/p>\n\n\n\n<p>\u663e\u793a\u53c2\u6570\u8bbe\u7f6e\u3002\u53c2\u8003 <a href=\"https:\/\/www.gbase8.cn\/105\">GBase8a \u96c6\u7fa4\u67e5\u770b\u6570\u636e\u5e93\u53c2\u6570\u7684\u5f53\u524d\u503c<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"show_vcs\"><\/span>show vcs<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u663e\u793aVC\u5217\u8868\u3002 V95\u652f\u6301vC\u7684\u7248\u672c\u624d\u6709\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>gbase&gt; show vcs;\n+---------+--------------+---------+\n| id      | name         | default |\n+---------+--------------+---------+\n| vc00001 | vcname000001 | Y       |\n+---------+--------------+---------+\n1 row in set (Elapsed: 00:00:00.00)\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"show_warnings\"><\/span>show warnings<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u663e\u793a\u544a\u8b66\u4fe1\u606f<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>gbase&gt; show warnings;\nEmpty set (Elapsed: 00:00:00.00)\n\ngbase&gt; show warnings limit 3,1;\nEmpty set (Elapsed: 00:00:00.00)\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"show_views\"><\/span>show views<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u663e\u793a\u89c6\u56fe\u3002\u5f53\u524d\u7248\u672c\u5c1a\u4e0d\u652f\u6301\u8fd9\u4e2a\u5199\u6cd5\uff0c\u4f46\u53ef\u4ee5\u901a\u8fc7\u5982\u4e0b\u65b9\u6cd5\u83b7\u5f97<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>show full tables where table_type='VIEW'\n\ngbase> create view testdb.v_tr as select * from tr;\r\nQuery OK, 0 rows affected (Elapsed: 00:00:00.00)\r\n\r\ngbase> show full tables where table_type='VIEW';\r\n+------------------+------------+\r\n| Tables_in_testdb | Table_type |\r\n+------------------+------------+\r\n| v_tr             | VIEW       |\r\n+------------------+------------+\r\n1 row in set (Elapsed: 00:00:00.00)\r\n<\/code><\/pre>\n\n\n\n<p>\u8be6\u60c5\u8bf7\u53c2\u8003<a href=\"https:\/\/www.gbase8.cn\/88\"> GBase8a \u96c6\u7fa4\u67e5\u770b\u5e93\u91cc\u6709\u54ea\u4e9b\u89c6\u56fe(\u7c7b\u4f3c show views)<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5357\u5927\u901a\u7528GBase 8a\u63d0\u4f9b\u4e86show \u7ba1\u7406\u547d\u4ee4\uff0c\u6765\u67e5\u770b\u5404\u79cd\u6570\u636e\u5e93\u4fe1\u606f\uff0c\u672c\u6587\u53ea\u662f\u8bed\u6cd5\u7ea7\u7684\u7b80\u5355\u4ecb\u7ecd\u548c\u4e00\u4e9b\u4f7f\u7528\u6837\u4f8b\u3002<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-2436","post","type-post","status-publish","format-standard","hentry","category-gbase8a"],"_links":{"self":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/2436","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/comments?post=2436"}],"version-history":[{"count":72,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/2436\/revisions"}],"predecessor-version":[{"id":12060,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/2436\/revisions\/12060"}],"wp:attachment":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/media?parent=2436"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/categories?post=2436"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/tags?post=2436"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}