excel到mysql数据导入的简短而甜蜜的解决方案:
适用于txt文件格式 . 详细地:
tbl name=t1
feilds are= name varchar,email varchar;
text.txt文件<< ==这个文本文件第一行表列名:
name, email
"n1", "e1" next line
"n2", "e2" next line
"n3", "e3" next line
"n4", "e4" next line
"n5", "e5" next line
"n6", "e6" next line
"n7", "e7" next line
请忽略下一行语句在wamp中的SQL查询
LOAD DATA INFILE 'c:/wamp/www/touch/text.txt' INTO TABLE t1 FIELDS TERMINATED BY ',' ENCLOSED BY '\"' LINES TERMINATED BY '\r\n' IGNORE 1 LINES(name,email)
为了成功运行此commnad,我们分别创建了文件夹 .
真实的是
C:\ wamp \ mysql \ data \ wamp \ www \ touch \ text.txt << == pysical文件路径是 .
但我们提到c:/wamp/touch/text.txt