如何将文本文件中的数据导入mysql数据库
我有一个名为 text_file.txt 的 350MB 文件，其中包含此制表符分隔的数据:
I have a 350MB file named text_file.txt containing this tab delimited data:
345868230 1646198120 1531283146 Keyword_1531283146 1.55 252910000
745345566 1646198120 1539847239 another_1531276364 2.75 987831000
...
MySQL 数据库名称:Xml_Date
MySQL Database name: Xml_Date
数据库表:PerformanceReport
我已经创建了包含所有目标字段的表.
I have already created the table with all the destination fields.
我想将此文本文件数据导入到 MySQL 中.我用谷歌搜索并找到了一些命令，例如 LOAD DATA INFILE 并且对如何使用它感到非常困惑.
I want to import this text file data into a MySQL. I googled and found some commands like LOAD DATA INFILE and quite confused on how to use it.
如何导入此文本文件数据?
How can I import this text file data?
推荐答案
应该就这么简单...
LOAD DATA INFILE '/tmp/mydata.txt' INTO TABLE PerformanceReport;
默认情况下 LOAD DATA INFILE 使用制表符分隔，每行一行，所以应该很好.
By default LOAD DATA INFILE uses tab delimited, one row per line, so should take it in just fine.
相关文章