MYSQL如何使用infile/outfile
这篇文章给大家分享的是有关MYSQL如何使用infile/outfile的内容。小编觉得挺实用的,因此分享给大家做个参考,一起跟随小编过来看看吧。
由于现有的东家要求使用MYSQL数据库,所以最近也开始了对MYSQL数据库的进一步的研究,首先介入的当然是一些正常的应用了:
outfile/infile的灵活:
今天接触了下mysql下的outfile和infile感觉和实际使用很贴切,不像ORACLE那么商业化,任何操作都要封装成自己的接口来实现、操作,MYSQL直接通过一个简单的语句就完成了数据的导入、导出,满足了日常的灵活性与可控性。
LOADDATA[LOW_PRIORITY|CONCURRENT][LOCAL]INFILE'file_name.txt'
[REPLACE|IGNORE]
INTOTABLEtbl_name
[FIELDS
[TERMINATEDBY'string']
[[OPTIONALLY]ENCLOSEDBY'char']
[ESCAPEDBY'char']
]
[LINES
[STARTINGBY'string']
[TERMINATEDBY'string']
]
[IGNOREnumberLINES]
[(col_name_or_user_var,...)]
[SETcol_name=expr,...)]
demo:
示例文件:
e.txt
===========================
12121234123434==============================
ab
==============================
1,2;3,4
==============================
mysql>loaddatainfile'd:e.txt'intotabletest1;QueryOK,7rowsaffected(0.13sec)Records:7Deleted:0Skipped:0Warnings:0mysql>loaddatainfile'd:e.txt'replaceintotabletest1;QueryOK,7rowsaffected(0.06sec)Records:7Deleted:0Skipped:0Warnings:0mysql>loaddatainfile'd:ab'replaceintotabletest1FIELDSTERMINATEDby','LINESTERMINATEDby';';QueryOK,2rowsaffected(0.09sec)Records:2Deleted:0Skipped:0Warnings:0mysql>loaddatainfile'd:e.txt'replaceintotabletest1FIELDSTERMINATEDby','LINESTERMINATEDby';'ignore2QueryOK,0rowsaffected(0.00sec)Records:0Deleted:0Skipped:0Warnings:0
outfile
mysql>select*intooutfile'd:out1.txt'fromtest1;QueryOK,23rowsaffected(0.00sec)mysql>select*intooutfile'd:out2.txt'FIELDSTERMINATEDby','fromtest1->;QueryOK,23rowsaffected(0.00sec)
mysql>select*intooutfile'd:out3.txt'FIELDSTERMINATEDby','linesterminatedby';'fromtest1->;QueryOK,23rowsaffected(0.02sec)
感谢各位的阅读!关于“MYSQL如何使用infile/outfile”这篇文章就分享到这里了,希望以上内容可以对大家有一定的帮助,让大家可以学到更多知识,如果觉得文章不错,可以把它分享出去让更多的人看到吧!
声明:本站所有文章资源内容,如无特殊说明或标注,均为采集网络资源。如若本站内容侵犯了原著者的合法权益,可联系本站删除。