http://wiki.eijux.com/index.php?action=history&feed=atom&title=MySQL_%E8%AF%AD%E5%8F%A5%EF%BC%9A%E6%95%B0%E6%8D%AE%E5%A4%84%E7%90%86%E8%AF%AD%E5%8F%A5%EF%BC%88DML%EF%BC%89%EF%BC%9ALOAD_DATA_%E8%AF%AD%E5%8F%A5 2026-04-29T10:34:52Z 本wiki上该页面的版本历史 MediaWiki 1.38.2 http://wiki.eijux.com/index.php?title=MySQL_%E8%AF%AD%E5%8F%A5%EF%BC%9A%E6%95%B0%E6%8D%AE%E5%A4%84%E7%90%86%E8%AF%AD%E5%8F%A5%EF%BC%88DML%EF%BC%89%EF%BC%9ALOAD_DATA_%E8%AF%AD%E5%8F%A5&diff=6538&oldid=prev 2023-03-31T15:12:28Z

<p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="zh-Hans-CN"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">←上一版本</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">2023年3月31日 (五) 23:12的版本</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">第1行：</td> <td colspan="2" class="diff-lineno">第1行：</td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>[[category:<del style="font-weight: bold; text-decoration: none;">MySQL</del>]]</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>[[category:<ins style="font-weight: bold; text-decoration: none;">MySQL文档</ins>]]</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== 关于 ==</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== 关于 ==</div></td></tr> </table>

Eijux http://wiki.eijux.com/index.php?title=MySQL_%E8%AF%AD%E5%8F%A5%EF%BC%9A%E6%95%B0%E6%8D%AE%E5%A4%84%E7%90%86%E8%AF%AD%E5%8F%A5%EF%BC%88DML%EF%BC%89%EF%BC%9ALOAD_DATA_%E8%AF%AD%E5%8F%A5&diff=2334&oldid=prev 2021-04-13T19:09:44Z

<p>建立内容为“<a href="/%E5%88%86%E7%B1%BB:MySQL" title="分类:MySQL">category:MySQL</a> == 关于 == &lt;syntaxhighlight lang=&quot;mysql&quot;&gt; LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE &#039;file_name&#039; [REPLACE | IGNORE]…”的新页面</p> <p><b>新页面</b></p><div>[[category:MySQL]]<br /> <br /> == 关于 ==<br /> &lt;syntaxhighlight lang=&quot;mysql&quot;&gt;<br /> LOAD DATA<br /> [LOW_PRIORITY | CONCURRENT] [LOCAL]<br /> INFILE 'file_name'<br /> [REPLACE | IGNORE]<br /> INTO TABLE tbl_name<br /> [PARTITION (partition_name [, partition_name] ...)]<br /> [CHARACTER SET charset_name]<br /> [{FIELDS | COLUMNS}<br /> [TERMINATED BY 'string']<br /> [[OPTIONALLY] ENCLOSED BY 'char']<br /> [ESCAPED BY 'char']<br /> ]<br /> [LINES<br /> [STARTING BY 'string']<br /> [TERMINATED BY 'string']<br /> ]<br /> [IGNORE number {LINES | ROWS}]<br /> [(col_name_or_user_var<br /> [, col_name_or_user_var] ...)]<br /> [SET col_name={expr | DEFAULT}<br /> [, col_name={expr | DEFAULT}] ...]<br /> &lt;/syntaxhighlight&gt;<br /> LOAD DATA 语句'''以非常高的速度将文本文件中的行读取到 table 中'''。 LOAD DATA 是“SELECT ... INTO OUTFILE”的补充。<br /> # 要将数据从 table 写入文件，请使用“'''SELECT ... INTO OUTFILE'''”。<br /> # 要将文件读回到 table 中，请使用“LOAD DATA”。<br /> * 两条语句的 FIELDS 和 LINES 子句的语法相同。<br /> <br /> == 分区表支持 ==<br /> <br /> == 输入文件名，位置和内容解释 ==<br /> <br /> == 并发注意事项 ==<br /> <br /> == 重复键处理 ==<br /> <br /> == 索引处理 ==<br /> <br /> == FIELDS 和 LINES 处理 ==<br /> <br /> == 列的列表规范 ==<br /> <br /> == 输入预处理 ==<br /> <br /> == 报表结果信息 ==<br /> <br /> == 杂项 ==</div>

Eijux