<\/span><\/h3>\n\n\n\n\u5148\u5efa1\u4e2a\u4e24\u5217\u7684\u8868<\/p>\n\n\n\n
gbase> create table tt(id int, name varchar(100));\nQuery OK, 0 rows affected (Elapsed: 00:00:02.43)\n\ngbase> desc tt;\n+-------+--------------+------+-----+---------+-------+\n| Field | Type | Null | Key | Default | Extra |\n+-------+--------------+------+-----+---------+-------+\n| id | int(11) | YES | | NULL | |\n| name | varchar(100) | YES | | NULL | |\n+-------+--------------+------+-----+---------+-------+\n2 rows in set (Elapsed: 00:00:00.00)\n<\/code><\/pre>\n\n\n\n\u518d\u589e\u52a02\u4e2a\u5217\u5230id\u540e\u9762\uff0c\u6ce8\u610f\u987a\u5e8f\u662fid,id3\uff0cid2,name \u4e86\u3002<\/p>\n\n\n\n
gbase> alter table tt add column id2 int after id;\nQuery OK, 0 rows affected (Elapsed: 00:00:00.30)\nRecords: 0 Duplicates: 0 Warnings: 0\n\ngbase> alter table tt add column id3 int after id;\nQuery OK, 0 rows affected (Elapsed: 00:00:00.28)\nRecords: 0 Duplicates: 0 Warnings: 0\n\ngbase> desc testdb.tt;\n+-------+--------------+------+-----+---------+-------+\n| Field | Type | Null | Key | Default | Extra |\n+-------+--------------+------+-----+---------+-------+\n| id | int(11) | YES | | NULL | |\n| id3 | int(11) | YES | | NULL | |\n| id2 | int(11) | YES | | NULL | |\n| name | varchar(100) | YES | | NULL | |\n+-------+--------------+------+-----+---------+-------+\n4 rows in set (Elapsed: 00:00:00.00)\n\n<\/code><\/pre>\n\n\n\n<\/span>\u6d4b\u8bd5<\/span><\/h2>\n\n\n\n<\/span>\u5217\u987a\u5e8f<\/span><\/h3>\n\n\n\n\u5c31\u662f\u5982\u4e0a\u7684desc\u7684\u987a\u5e8f\uff0c\u5982\u679c\u8981\u66f4\u7cbe\u7ec6\u7684\uff0c\u53ef\u4ee5\u67e5\u8be2\u5143\u6570\u636e\u8868columns<\/p>\n\n\n\n
gbase> select column_name,ORDINAL_POSITION from information_schema.columns where table_schema='testdb' and table_name='tt';\n+-------------+------------------+\n| column_name | ORDINAL_POSITION |\n+-------------+------------------+\n| id | 1 |\n| id3 | 2 |\n| id2 | 3 |\n| name | 4 |\n+-------------+------------------+\n4 rows in set (Elapsed: 00:00:00.01)\n<\/code><\/pre>\n\n\n\n<\/span>\u5217\u6570\u636e\u6587\u4ef6<\/span><\/h3>\n\n\n\n\u901a\u8fc7show full create tablle XXXX \u53ef\u4ee5\u770b\u5230COLUMN_IDS\uff0c\u6807\u8bc6\u5217\u7684\u540d\u5b57\u987a\u5e8f<\/p>\n\n\n\n
gbase> show full create table tt;\r\n+-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\r\n| Table | Create Table |\r\n+-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\r\n| tt | CREATE TABLE \"tt\" (\r\n \"id\" int(11) DEFAULT NULL,\r\n \"id3\" int(11) DEFAULT NULL,\r\n \"id2\" int(11) DEFAULT NULL,\r\n \"name\" varchar(100) DEFAULT NULL\r\n) ENGINE=EXPRESS TID(297) UID(1) DEFAULT CHARSET=utf8 TABLESPACE='sys_tablespace' COLUMN_IDS(0, 3, 2, 1)<\/span> |\r\n+-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\r\n1 row in set (Elapsed: 00:00:00.00)\r\n<\/code><\/pre>\n\n\n\n\u53ef\u4ee5\u770b\u5230\u5217\u6587\u4ef6\u90fd\u662fC\u5f00\u5934\u7684\uff0c\u5305\u542b\u9012\u589e\u6570\u5b57\u7684.seg\u6587\u4ef6\u3002\u5176\u4e2dC00000\u662f\u7b2c1\u7ec4\uff0cC00001\u662f\u7b2c2\u7ec4\u3002\u5982\u4e0b\u56fe\u53ef\u4ee5\u770b\u5230\u51714\u7ec4\uff0c\u5bf9\u5e944\u4e2a\u5217\u6587\u4ef6\u3002<\/p>\n\n\n\n
\u5982\u679c\u8868\u521b\u5efa\u540e\uff0c\u6ca1\u6709\u505a\u8fc7\u5220\u9664\uff0c\u4e2d\u95f4\u6dfb\u52a0\u5217\u7684\u64cd\u4f5c\uff0c\u90a3\u4e48\u5217\u6587\u4ef6\u7684\u987a\u5e8f\u5c31\u548c\u8868\u5217\u7684\u987a\u5e8f\u5b8c\u5168\u5bf9\u5e94\u3002 \u7b2c1\u5217=C00000, \u7b2c2\u5217=C00001\u3002<\/p>\n\n\n\n
\u5982\u679c\u5220\u9664\u6dfb\u52a0\u8fc7\uff0c\u770b\u540e\u9762\u7684\u4ecb\u7ecd\u3002<\/p>\n\n\n\n
[root@rh6-1 tt_n1]# ll\ntotal 28\n-rw------- 1 gbase gbase 40 May 19 12:53 C00000.seg\n-rw------- 1 gbase gbase 37 May 19 12:52 C00000.seg.1\n-rw------- 1 gbase gbase 114 May 19 12:53 C00001.seg\n-rw------- 1 gbase gbase 91 May 19 12:52 C00001.seg.1\n-rw------- 1 gbase gbase 37 May 19 12:52 C00002.seg\n-rw------- 1 gbase gbase 40 May 19 12:53 C00002.seg.1\n-rw------- 1 gbase gbase 40 May 19 12:53 C00003.seg\n[root@rh6-1 tt_n1]# \n<\/code><\/pre>\n\n\n\n<\/span>\u6570\u636e\u6587\u4ef6\u548c\u5217\u5bf9\u5e94\u5173\u7cfb<\/span><\/h3>\n\n\n\n<\/span>\u901a\u8fc7show full create table<\/span><\/h4>\n\n\n\nshow full create table XXX\u7684\u6700\u7b80\u5355\uff0cCOLUMN_IDS(0, 3, 2, 1) \u8868\u793a\u5bf9\u5e941\uff0c2\uff0c3\uff0c4\u5217\u7684\u6587\u4ef6\u987a\u5e8f\u662f0,3,2,1<\/p>\n\n\n\n
gbase> show full create table tt;\r\n+-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\r\n| Table | Create Table |\r\n+-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\r\n| tt | CREATE TABLE \"tt\" (\r\n \"id\" int(11) DEFAULT NULL,\r\n \"id3\" int(11) DEFAULT NULL,\r\n \"id2\" int(11) DEFAULT NULL,\r\n \"name\" varchar(100) DEFAULT NULL\r\n) ENGINE=EXPRESS TID(297) UID(1) DEFAULT CHARSET=utf8 TABLESPACE='sys_tablespace' COLUMN_IDS(0, 3, 2, 1) |\r\n+-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\r\n1 row in set (Elapsed: 00:00:00.00)\r\n<\/code><\/pre>\n\n\n\n<\/span>\u901a\u8fc7\u5143\u6570\u636e\u6587\u4ef6metadump<\/span><\/h4>\n\n\n\n<\/span>V86\u7248\u672c<\/span><\/h5>\n\n\n\n\u8fdb\u5165\u8868\u7684\u5143\u6570\u636e\u76ee\u5f55(metadata\/\u8868\u540d.GED)\uff0c \u8fd0\u884cmetadump table.des.B \u6216\u8005A\u3002\u5176\u4e2d\u7684attr_nums\u5bf9\u5e94\u5217\uff0c\u91cc\u9762\u7684\u6570\u5b57\u5bf9\u5e94\u5217\u987a\u5e8f\uff0c\u540e\u9762\u7684\u503c\u5bf9\u5e94CXXXXX\u7684\u987a\u5e8f\u3002\u5982\u4e0b\u662f\u6458\u5f55\u7684<\/p>\n\n\n\n
0 = id = C00000
1 = id3 = C00003
2 = id2 = C00002
3 = name = C00001<\/p>\n\n\n\n
[gbase@rh6-1 tt.GED]$ metadump table.des.B\nThis tool is designed for use at GBase internally,and is unsupported externally.\nGBase makes no claims and holds no liability regarding the external use of this tool.\nThis tool is copyrighted and his redistribution is restricted.\ntable.des.B\n+----------------------+-----------------+\n| storage_version | GEHV7 |\n| encrypt | 0 |\n| shrinked_rowid | 0 |\n| no_attr | 4 |\n| attr_nums[0] | 0 |\n| attr_nums[1] | 3 |\n| attr_nums[2] | 2 |\n| attr_nums[3] | 1 |<\/span>\n| no_attr_cnt | 4 |\n| no_attr[0] | 1 |\n| no_attr[1] | 1 |\n..... \u5176\u4f59\u7684\u4e0d\u5199\u4e86<\/code><\/pre>\n\n\n\n<\/p>\n\n\n\n
<\/span>V95\u7248\u672c<\/span><\/h5>\n\n\n\n\u540c\u6837\u662fmetadata\/\u8868\u540d.GED\u76ee\u5f55\uff0c\u7528table.info.B\/A, \u9700\u8981\u7528grep\u8fc7\u6ee4\u4e0b\u3002 \u5982\u4e0b\u7684\u8f93\u51fa\uff0c\u53ef\u4ee5\u83b7\u5f97\u548cV86\u76f8\u540c\u7684\u7ed3\u679c\u3002<\/p>\n\n\n\n
0 = id = C00000
1 = id3 = C00003
2 = id2 = C00002
3 = name = C00001<\/p>\n\n\n\n
[gbase@localhost tt.GED]$ metadump table.info.B | grep attr\n| no_attr | 4 |\n| no_attr_cnt | 4 |\n---------------------------attr 0<\/span>------------------------\n| attr_number | 0 <\/span> |\n---------------------------attr 1------------------------\n| attr_number | 3 <\/span> |\n---------------------------attr 2------------------------\n| attr_number | 2 <\/span> |\n---------------------------attr 3------------------------\n| attr_number | 1 <\/span> |\n\n\n\u6216\u8005\n[gbase@localhost tt.GED]$ metadump table.info.B | grep attr_number\n| attr_number | 0 |\n| attr_number | 3 |\n| attr_number | 2 |\n| attr_number | 1 |<\/span>\n<\/code><\/pre>\n\n\n\n<\/span>\u5220\u9664\u5217\u6d4b\u8bd5<\/span><\/h4>\n\n\n\nbase> alter table tt drop column id2;\nQuery OK, 0 rows affected (Elapsed: 00:00:00.32)\nRecords: 0 Duplicates: 0 Warnings: 0\n\ngbase> desc testdb.tt;\n+-------+--------------+------+-----+---------+-------+\n| Field | Type | Null | Key | Default | Extra |\n+-------+--------------+------+-----+---------+-------+\n| id | int(11) | YES | | NULL | |\n| id3 | int(11) | YES | | NULL | |\n| name | varchar(100) | YES | | NULL | |\n+-------+--------------+------+-----+---------+-------+\n3 rows in set (Elapsed: 00:00:00.00)\n\n<\/code><\/pre>\n\n\n\n\u67e5\u770b\u987a\u5e8f\uff0c\u5bf9\u5e940\uff0c3\uff0c1\uff0c \u5176\u4e2dC00002\u6d88\u5931\u4e86\u3002<\/p>\n\n\n\n
[gbase@localhost tt.GED]$ ll \/opt\/gbase\/gnode\/userdata\/gbase\/testdb\/sys_tablespace\/tt_n1\/\ntotal 12\n-rw------- 1 gbase gbase 42 May 19 14:07 C00000.seg.1\n-rw------- 1 gbase gbase 98 May 19 14:07 C00001.seg.1\n-rw------- 1 gbase gbase 42 May 19 14:07 C00003.seg\n[gbase@localhost tt.GED]$\n\n[gbase@localhost tt.GED]$ metadump table.info.B | grep attr\n| no_attr | 3 |\n| no_attr_cnt | 4 |\n---------------------------attr 0------------------------\n| attr_number | 0 |\n---------------------------attr 1------------------------\n| attr_number | 3 |\n---------------------------attr 2------------------------\n| attr_number | 1 |\n<\/code><\/pre>","protected":false},"excerpt":{"rendered":"\u5357\u5927\u901a\u7528GBase 8a\u96c6\u7fa4\u91cc\u9ed8\u8ba4\u6309\u7167\u5efa\u8868\u8bed\u53e5\u7684\u5b57\u6bb5\u5148\u540e\u987a\u5e8f\uff0c\u5728\u78c1\u76d8\u4e0a\u751f\u6210\u6587\u4ef6\u540d\u9012\u589e\u7684\u7c7b\u4f3cC00000.seg\u6570\u636e\u6587\u4ef6\u3002\u4f46\u5f53\u8868\u7684\u5217\u51fa\u73b0\u5220\u9664\uff0c\u65b0\u589e\u540e\uff0c\u5217\u7684\u987a\u5e8f\u4e0e\u78c1\u76d8\u6587\u4ef6\u540d\u7684\u987a\u5e8f\u5c06\u4e0d\u518d\u4fdd\u969c\u5bf9\u5e94\u3002\u672c\u6587\u4ecb\u7ecd\u5982\u4f55\u627e\u5230\u67d0\u4e00\u4e2a\u5217\u7684\u6570\u636e\u6587\u4ef6\u7684\u65b9\u6cd5\u3002<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-9408","post","type-post","status-publish","format-standard","hentry","category-gbase8a"],"_links":{"self":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/9408","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=9408"}],"version-history":[{"count":14,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/9408\/revisions"}],"predecessor-version":[{"id":9637,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/9408\/revisions\/9637"}],"wp:attachment":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/media?parent=9408"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/categories?post=9408"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/tags?post=9408"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}