56,677
社区成员
发帖
与我相关
我的任务
分享load data infile的局限性
txt文本有2万行，每行4列数据，用tab分隔符分开。
mysql一张表里有一个自动增长的id字段和另外7个字段，我想把txt里的4列数据导入表中指定的字段，该怎么半呢？
mysql一张表里有一个自动增长的id字段和另外7个字段，我想把txt里的4列数据导入表中指定的字段，该怎么半呢？
...全文
请发表友善的回复…
发表回复
ldb2741 2010-02-02
- 打赏
- 举报
惭愧，多谢ACMAIN_CHM
ACMAIN_CHM 2010-02-02
- 打赏
- 举报
手册中的例子
LOAD DATA INFILE 'persondata.txt' INTO TABLE persondata (col1,col2,...);
LOAD DATA INFILE 'persondata.txt' INTO TABLE persondata (col1,col2,...);
ACMAIN_CHM 2010-02-02
- 打赏
- 举报
语法如下啊，注意红色部分的用途
LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name'
[REPLACE | IGNORE]
INTO TABLE tbl_name
[CHARACTER SET charset_name]
[{FIELDS | COLUMNS}
[TERMINATED BY 'string']
[[OPTIONALLY] ENCLOSED BY 'char']
[ESCAPED BY 'char']
]
[LINES
[STARTING BY 'string']
[TERMINATED BY 'string']
]
[IGNORE number LINES]
[(col_name_or_user_var,...)]
[SET col_name = expr,...]
MySQL官方文档 http://dev.mysql.com/doc/refman/5.1/zh/index.html
LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name'
[REPLACE | IGNORE]
INTO TABLE tbl_name
[CHARACTER SET charset_name]
[{FIELDS | COLUMNS}
[TERMINATED BY 'string']
[[OPTIONALLY] ENCLOSED BY 'char']
[ESCAPED BY 'char']
]
[LINES
[STARTING BY 'string']
[TERMINATED BY 'string']
]
[IGNORE number LINES]
[(col_name_or_user_var,...)]
[SET col_name = expr,...]
MySQL官方文档 http://dev.mysql.com/doc/refman/5.1/zh/index.html
