<\/span><\/h3>\n\n\n\n\u5bfc\u51fa\u6587\u4ef6\u8868\u5934\u5927\u5c0f\u5199\u654f\u611f\u529f\u80fd\u5f00\u5173\u3002<\/p>\n\n\n\n
1=\u654f\u611f\u3002\u5982\u679c\u7528\u7684*,\u5219\u4e0e\u8868\u7ed3\u6784\u4fdd\u6301\u4e00\u81f4\u3002
0=\u4e0d\u654f\u611f\uff0c\u6539\u6210\u5c0f\u5199\u3002\u9ed8\u8ba4\u503c<\/p>\n\n\n\n
_gcluster_support_outfile_with_table_head_case_sensitive<\/code><\/pre>\n\n\n\n<\/span>\u6837\u4f8b<\/span><\/h3>\n\n\n\n\u5982\u4e0b\u901a\u8fc7\u53c2\u6570\uff0c\u5c06MB\u548cMb\u505a\u4e86\u5bfc\u51fa\u6587\u4ef6\u7684\u8868\u5934\u533a\u5206\u3002 select into outfile with head<\/p>\n\n\n\n
gbase> show variables like '%sensitive%';\n+----------------------------------------------------------+-------+\n| Variable_name | Value |\n+----------------------------------------------------------+-------+\n| _gcluster_support_outfile_with_table_head_case_sensitive | 0 |\n| gbase_show_ident_case_sensitive | 0 |\n| gcluster_dblink_orcl_case_sensitive | 0 |\n+----------------------------------------------------------+-------+\n3 rows in set (Elapsed: 00:00:00.00)\n\ngbase> set _gcluster_support_outfile_with_table_head_case_sensitive=1;\nQuery OK, 0 rows affected (Elapsed: 00:00:00.00)\n\ngbase>\ngbase> select 123 as MB,456 as Mb from dual into outfile '\/home\/gbase\/t1.txt' with head writemode by overwrites;\nQuery OK, 1 row affected (Elapsed: 00:00:00.00)\n\ngbase> system cat \/home\/gbase\/t1.txt\/t1.txt\nMB Mb\n123 456\ngbase><\/code><\/pre>\n\n\n\n\u4e0e\u8868\u7ed3\u6784\u4fdd\u6301\u4e00\u81f4<\/p>\n\n\n\n
gbase> desc t1;\r\n+-------+--------------+------+-----+---------+-------+\r\n| Field | Type | Null | Key | Default | Extra |\r\n+-------+--------------+------+-----+---------+-------+\r\n| id | int(11) | YES | | NULL | |\r\n| Name | varchar(100) | YES | | NULL | |\r\n+-------+--------------+------+-----+---------+-------+\r\n2 rows in set (Elapsed: 00:00:00.00)\r\ngbase> select * from t1 into outfile '\/home\/gbase\/t1_1_star.txt' writemode by overwrites with head;\r\nQuery OK, 4 rows affected (Elapsed: 00:00:00.02)\r\ngbase> system cat \/home\/gbase\/t1_1_star.txt\r\nid Name\r\n1 \\N\r\n2 \\N\r\n4 \\N\r\n8 \\N\r\ngbase><\/code><\/pre>","protected":false},"excerpt":{"rendered":"\u5357\u5927\u901a\u7528GBase 8a\u63d0\u4f9b\u4e862\u7c7b\u573a\u666f\u6765\u652f\u6301\u5927\u5c0f\u5199\uff1a\u7b2c\u4e00\u662f\u67e5\u770b\u8868\u7ed3\u6784\uff0c\u652f\u6301\u9ed8\u8ba4\uff0c\u5168\u6539\u5c0f\u5199\uff0c\u5168\u6539\u5927\u5199\u7684\u8f93\u51fa\uff1b\u7b2c\u4e8c\u662f\u67e5\u8be2\u5e26\u8868\u5934\u7684\u5bfc\u51fawith head, \u652f\u6301\u662f\u5426\u5927\u5c0f\u5199\u654f\u611f\uff0c\u9ed8\u8ba4\u8f93\u51fa\u5c0f\u5199\u3002<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[],"class_list":["post-236","post","type-post","status-publish","format-standard","hentry","category-gbase8a"],"_links":{"self":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/236","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=236"}],"version-history":[{"count":10,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/236\/revisions"}],"predecessor-version":[{"id":13211,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/236\/revisions\/13211"}],"wp:attachment":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/media?parent=236"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/categories?post=236"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/tags?post=236"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}