如何在phpmyadmin中将分隔数据导入mysql
这是我使用的数据示例
24701||37.279788||-81.229023||WV||BLUEFIELD||MERCER
正如你所看到的,它是用双管道分隔的.phpmyadmin 要求我提供以下内容
as you can see its double pipe delimited. phpmyadmin is asking me for the following
Fields Terminated By
Fields Enclosed By
Fields Escaped By
Lines Terminated By
如何正确导入我的数据?
what do i put to correctly import my data?
推荐答案
mysqlimport 使用 --fields-terminated-by="||"
mysqlimport works with --fields-terminated-by="||"
Fields Terminated By ||
看起来 PHPMyAdmin 没有.然后你必须做一个替换,但要小心不要弄乱你的数据(即,如果你替换 || for ,请确保原始中没有更多的 , 字符)
Looks like PHPMyAdmin doesn't. Then you have to do a replace, but be careful that you aren't messing with your data (ie, if you replace || for , be sure there are no further , characters in the original)
相关文章