比如你的路径是:C:\example.txt 你的表是table1 example.txt内容为:1,2,3,4 5,6,7,8 ... load data infile 'c:\\example.txt' into table table1 fields terminated by ',' lines terminated by '\n'; 如果你的分隔符不是一致的,可以用EDITPLUS等工具的正则替换模式替换成一致的分隔符,然后导入即可。 如果数据格式是这样: "1","2","3","4" "5","6","7","8" ... load data infile 'c:\\example.txt' into table table1 fields terminated by ',' optionally enclosed by '"' lines terminated by '\n' 详情见:
比如你的路径是:C:\example.txt
你的表是table1
example.txt内容为:1,2,3,4
5,6,7,8
...
load data infile 'c:\\example.txt' into table table1 fields terminated by ',' lines terminated by '\n';
如果你的分隔符不是一致的,可以用EDITPLUS等工具的正则替换模式替换成一致的分隔符,然后导入即可。
如果数据格式是这样:
"1","2","3","4"
"5","6","7","8"
...
load data infile 'c:\\example.txt' into table table1 fields terminated by ',' optionally enclosed by '"' lines terminated by '\n'
详情见:
"5","6","7","8"
直接可以把这个文件比如my.txt改为my.csv,然后建立一个相同SCHEMA的表,不过她的类型是CSV的。这样就直接是数据了。不用导入。具体查看:MYSQL手册中关于CSV引擎的介绍。