如何将此数据文件导入Mysql表 [英] How do I import this data file to a Mysql table

问题描述

如何将该数据文件导入MySQL表？

How do I import this data file to MySQL table?

1,AF,Afghanistan
2,AX,Aland Islands
3,AL,Albania
4,DZ,Algeria
5,AS,American Samoa
6,AD,Andorra
7,AO,Angola
8,AI,Anguilla
9,AQ,Antarctica
10,AG,Antigua And Barbuda
11,AR,Argentina
12,AM,Armenia
13,AW,Aruba
14,AU,Australia
15,AT,Austria
16,AZ,Azerbaijan
17,BS,Bahamas
18,BH,Bahrain
19,BD,Bangladesh
20,BB,Barbados
21,BY,Belarus
22,BE,Belgium

推荐答案

加载数据查询以进行救援！

LOAD DATA queries to the rescue!

LOAD DATA INFILE '/tmp/test.txt' INTO TABLE test
FIELDS TERMINATED BY ',' 

有关 http://dev.mysql.com/doc/refman/5.1/en/load-data.html

这篇关于如何将此数据文件导入Mysql表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！