{"id":11696,"date":"2023-04-23T17:30:00","date_gmt":"2023-04-23T09:30:00","guid":{"rendered":"https:\/\/www.gbase8.cn\/?p=11696"},"modified":"2023-04-24T15:51:47","modified_gmt":"2023-04-24T07:51:47","slug":"gbase-8a%e5%af%bc%e5%87%ba%e5%ae%9a%e9%95%bf%e6%a0%bc%e5%bc%8f%e6%95%b0%e6%8d%ae%e6%96%87%e4%bb%b6%e7%9a%84%e6%96%b9%e6%b3%95","status":"publish","type":"post","link":"https:\/\/www.gbase8.cn\/en\/11696","title":{"rendered":"\u5357\u5927\u901a\u7528GBase 8a\u5bfc\u51fa\u5b9a\u957f\u683c\u5f0f\u6570\u636e\u6587\u4ef6\u7684\u65b9\u6cd5"},"content":{"rendered":"<p>\u5b9a\u957f\u683c\u5f0f\uff0c\u6bcf\u4e2a\u5b57\u6bb5\u5360\u7528\u76f8\u540c\u7684\u5b57\u8282\u6570\uff0c\u65e0\u9700\u518d\u8003\u8651\u5206\u9694\u7b26\uff0c\u53ef\u4ee5\u7b80\u5316\u52a0\u8f7d\u5904\u7406\u903b\u8f91\uff0c\u4f46\u4e00\u822c\u4f1a\u51fa\u73b0\u7a7a\u95f4\u6d6a\u8d39\u3002\u5f53\u6570\u636e\u5185\u5bb9\u590d\u6742\uff0c\u4e0d\u597d\u8bbe\u7f6e\u5408\u9002\u7684\u5206\u9694\u7b26\u65f6\uff0c\u5b9a\u957f\u53ef\u80fd\u662f\u552f\u4e00\u7684\u65b9\u6848\u3002\u672c\u6587\u4ecb\u7ecdGBase 8a\u5bfc\u51fa\u5b9a\u957f\u6570\u636e\u7684\u65b9\u6cd5\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\">Directory Navigation<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a2acc189b996\" 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-6a2acc189b996\"  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\/11696\/#%E5%8F%82%E8%80%83\" >\u53c2\u8003<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.gbase8.cn\/en\/11696\/#%E8%AF%AD%E6%B3%95\" >\u8bed\u6cd5<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.gbase8.cn\/en\/11696\/#%E6%96%B9%E6%B3%95%E4%B8%80%EF%BC%8C%E6%8C%87%E5%AE%9Alength\" >\u65b9\u6cd5\u4e00\uff0c\u6307\u5b9alength<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.gbase8.cn\/en\/11696\/#%E6%96%B9%E6%B3%952%E5%92%8C3%EF%BC%8C%E8%AE%BE%E7%BD%AE%E5%AD%97%E6%AE%B5%E5%88%86%E9%9A%94%E7%AC%A6%EF%BC%8C%E8%BD%AC%E4%B9%89%E7%AC%A6%E4%B8%BA%E7%A9%BA\" >\u65b9\u6cd52\u548c3\uff0c\u8bbe\u7f6e\u5b57\u6bb5\u5206\u9694\u7b26\uff0c\u8f6c\u4e49\u7b26\u4e3a\u7a7a<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%8F%82%E8%80%83\"><\/span>\u53c2\u8003<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p><a href=\"https:\/\/www.gbase8.cn\/en\/7144\/?hilite=%E5%AE%9A%E9%95%BF\">GBase 8a\u52a0\u8f7dLOAD<mark>\u5b9a\u957f<\/mark>\u683c\u5f0f\u7684\u6570\u636e\u65b9\u6cd5<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E8%AF%AD%E6%B3%95\"><\/span>\u8bed\u6cd5<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>select XX into outfile 'XXX' fields length(XX,XX,XX....)\nselect XX into outfile 'XXX' fields FIELDS TERMINATED BY '' ENCLOSED BY '' ESCAPED BY ''\nselect XX into outfile 'XXX' fields FIELDS TERMINATED BY '' ESCAPED BY ''<\/code><\/pre>\n\n\n\n<p>\u6ce8\u610f\uff0c\u5982\u679c\u5df2\u7ecf\u4f7f\u7528\u4e86\u7b2c\u4e00\u79cdlength\u65b9\u6cd5\uff0c\u4e0d\u80fd\u518d\u6307\u5b9a\u65b9\u6cd52\u548c3\u7684\u5b57\u6bb5\uff0c\u5426\u5219\u4f1a\u62a5\u8bed\u6cd5\u9519\u8bef\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>gbase&gt; SELECT * FROM t1 INTO OUTFILE '\/home\/gbase\/t1.zxq' FIELDS length '10,20' TERMINATED  BY '' ENCLOSED BY '' ESCAPED BY '' writemode by overwrites;\nERROR 1755 (HY000): Fields\/columns length conllided with fields\/columns enclosed by.<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E6%96%B9%E6%B3%95%E4%B8%80%EF%BC%8C%E6%8C%87%E5%AE%9Alength\"><\/span>\u65b9\u6cd5\u4e00\uff0c\u6307\u5b9alength<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u6bcf\u4e2a\u5bfc\u51fa\u7684\u5b57\u6bb5\u90fd\u8981\u6307\u5b9a\uff0c\u5bf9\u4e8e\u6570\u5b57\uff0c\u4e0d\u80fd\u5c0f\u4e8e\u9ed8\u8ba4\u957f\u5ea6\u3002\u6b64\u65f6\u5ffd\u7565\u8003\u8651\u5217\u5b9a\u4e49\u6307\u5b9a\u7684\u6570\u5b57\u957f\u5ea6\u53c2\u6570\u3002<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>tinyint\u957f\u5ea6\u4e3a4<\/li><li>smallint \u957f\u5ea6\u4e3a6<\/li><li>int\u957f\u5ea6\u4e3a11<\/li><li>bigint\u957f\u5ea6\u4e3a21<\/li><li>decimal \u5e26\u5c0f\u6570\u70b9\u7cbe\u5ea6\u7684\u957f\u5ea6\u4e0d\u80fd\u4f4e\u4e8e\u5b9a\u4e49\u7684\u957f\u5ea6+2\uff08\u5c0f\u6570\u70b9\u548c\u8d1f\u53f7\uff09\uff0c\u5982\u679c\u6ca1\u6709\u5c0f\u6570\u70b9\u7cbe\u5ea6\uff0c\u5219+1<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>gbase> SELECT * FROM t1 INTO OUTFILE '\/home\/gbase\/t1.zxq' FIELDS length '10,20'  writemode by overwrites;\nERROR 1149 (42000): Invalid length field, need length 11 for field 'id'.\n\ngbase> select id,f1 from tsi into outfile '\/home\/gbase\/t.out' fields length '1,5';\r\nERROR 1149 (42000): Invalid length field, need length 6 for field 'id'.\r\ngbase>\r\ngbase> create table tti(id tinyint,f1 varchar(10));\r\nQuery OK, 0 rows affected (Elapsed: 00:00:00.14)\r\n\r\ngbase> select id,f1 from tti into outfile '\/home\/gbase\/t.out' fields length '1,5';\r\nERROR 1149 (42000): Invalid length field, need length 4 for field 'id'.\r\n\ngbase> select id,f1 from ttt into outfile '\/home\/gbase\/t.out' fields length '6,5';\r\nERROR 1149 (42000): Invalid length field, need length 21 for field 'id'.\n\ngbase> create table tdecimal(id decimal(32,5),f1 varchar(10));\r\nQuery OK, 0 rows affected (Elapsed: 00:00:00.13)\r\n\r\ngbase> select id,f1 from tdecimal into outfile '\/home\/gbase\/t.out' fields length '1,5';\r\nERROR 1149 (42000): Invalid length field, need length 34 for field 'id'.\n\r\ngbase> create table tdecimal2(id decimal(32,0),f1 varchar(10));\r\nQuery OK, 0 rows affected (Elapsed: 00:00:00.16)\r\n\r\ngbase> select id,f1 from tdecimal2 into outfile '\/home\/gbase\/t.out' fields length '1,5';\r\nERROR 1149 (42000): Invalid length field, need length 33 for field 'id'.<\/code><\/pre>\n\n\n\n<p><strong><span class=\"has-inline-color has-luminous-vivid-orange-color\">\u6ce8\u610f\uff1a\u957f\u5ea6\u4e3a\u5b57\u8282\u957f\u5ea6<\/span><\/strong>\u3002\u6570\u636e\u5e93\u5185\u5b57\u6bb5\u5b9a\u4e49varchar\u662f\u5b57\u7b26\u957f\u5ea6\uff0c\u8981\u6839\u636e\u5b57\u7b26\u96c6\uff0c\u6309\u6bd4\u4f8b\u8ba1\u7b97\u3002\u6bd4\u5982UTF8\u8981\u63091\u4e2a\u5b57\u7b263\u4e2a\u5b57\u8282\uff0cutf8mb4\u8981\u6309\u71671\u4e2a\u5b57\u7b264\u4e2a\u5b57\u8282\u3002<\/p>\n\n\n\n<p>\u6bd4\u5982utf8\u5b57\u7b26\u96c6\u7684 varchar(10\uff09\u5b9e\u9645\u7684\u5b57\u8282\u957f\u5ea6\u662f30\u3002\u5982\u679c\u914d\u7f6e\u7684\u957f\u5ea6\u5c0f\u4e8e\u5b9e\u9645\u6570\u503c\u7684\u5b57\u8282\u957f\u5ea6\uff0c\u5219\u4f1a\u51fa\u73b0\u622a\u65ad\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>gbase&gt; SELECT * FROM t1 INTO OUTFILE '\/home\/gbase\/t1.zxq' FIELDS length '11,2'  writemode by overwrites;\nQuery OK, 1 row affected (Elapsed: 00:00:00.03)\n\n\u6b63\u5e38\u7684\n&#91;root@gbase_rh7_001 t1.zxq]# cat t1.zxq\n1           From vc1\n\n\n\u88ab\u622a\u65ad\u7684\n&#91;root@gbase_rh7_001 t1.zxq]# cat t1.zxq\n1          Fr\n&#91;root@gbase_rh7_001 t1.zxq]#\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E6%96%B9%E6%B3%952%E5%92%8C3%EF%BC%8C%E8%AE%BE%E7%BD%AE%E5%AD%97%E6%AE%B5%E5%88%86%E9%9A%94%E7%AC%A6%EF%BC%8C%E8%BD%AC%E4%B9%89%E7%AC%A6%E4%B8%BA%E7%A9%BA\"><\/span>\u65b9\u6cd52\u548c3\uff0c\u8bbe\u7f6e\u5b57\u6bb5\u5206\u9694\u7b26\uff0c\u8f6c\u4e49\u7b26\u4e3a\u7a7a<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u8fd93\u4e2a\u53c2\u6570\uff0c\u53ea\u8981\u4efb\u4f55\u4e00\u4e2a\u8bbe\u7f6e\u4e0d\u4e3a\u7a7a\uff0c\u5219\u4e0d\u662f\u5b9a\u957f\u5bfc\u51fa\u3002\u53ea\u662f\u5b57\u6bb5\u5206\u9694\u7b26\u548c\u8f6c\u4e49\u7b26\u8bbe\u7f6e\u662f\u7a7a\u4e3a\u5224\u65ad\u6807\u8bb0\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>gbase&gt; SELECT * FROM t1 INTO OUTFILE '\/home\/gbase\/t1.zxq' FIELDS TERMINATED  BY '' ENCLOSED BY '' ESCAPED BY '' writemode by overwrites;\nQuery OK, 1 row affected (Elapsed: 00:00:00.03)\n\ngbase&gt; SELECT * FROM t1 INTO OUTFILE '\/home\/gbase\/t1.zxq' FIELDS TERMINATED  BY ''  ESCAPED BY '' writemode by overwrites;\nQuery OK, 1 row affected (Elapsed: 00:00:00.02)\n\n<\/code><\/pre>\n\n\n\n<p><\/p>","protected":false},"excerpt":{"rendered":"<p>\u5b9a\u957f\u683c\u5f0f\uff0c\u6bcf\u4e2a\u5b57\u6bb5\u5360\u7528\u76f8\u540c\u7684\u5b57\u8282\u6570\uff0c\u65e0\u9700\u518d\u8003\u8651\u5206\u9694\u7b26\uff0c\u53ef\u4ee5\u7b80\u5316\u52a0\u8f7d\u5904\u7406\u903b\u8f91\uff0c\u4f46\u4e00\u822c\u4f1a\u51fa\u73b0\u7a7a\u95f4\u6d6a\u8d39\u3002\u5f53\u6570\u636e\u5185\u5bb9\u590d\u6742\uff0c\u4e0d\u597d\u8bbe\u7f6e\u5408\u9002\u7684\u5206\u9694\u7b26\u65f6\uff0c\u5b9a\u957f\u53ef\u80fd\u662f\u552f\u4e00\u7684\u65b9\u6848\u3002\u672c\u6587\u4ecb\u7ecdGBase 8a\u5bfc\u51fa\u5b9a\u957f\u6570\u636e\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":[3],"tags":[22],"class_list":["post-11696","post","type-post","status-publish","format-standard","hentry","category-gbase8a","tag-22"],"_links":{"self":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/11696","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=11696"}],"version-history":[{"count":27,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/11696\/revisions"}],"predecessor-version":[{"id":11744,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/11696\/revisions\/11744"}],"wp:attachment":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/media?parent=11696"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/categories?post=11696"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/tags?post=11696"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}