如何在phpmyadmin中将分隔数据导入mysql [英] how to import delimited data into mysql in phpmyadmin

问题描述

这是我使用的数据示例

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)

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