开发者

phpMyAdmin Import .txt file?

开发者 https://www.devze.com 2023-04-05 10:03 出处:网络
I receive开发者_如何学God a database in this format: FB_BRANDID|FB_MODELID|FB_TEXTID|FB_TEXT|FB_TYPEID|FB_COUNTRYID

I receive开发者_如何学God a database in this format:

FB_BRANDID|FB_MODELID|FB_TEXTID|FB_TEXT|FB_TYPEID|FB_COUNTRYID
19|5783|38742|mn_4x4_synchrone_l.jpg|10|1
19|5783|38744|mn_4x4_synchrone_s.jpg|11|1
... and so on

Is there any way to imprt that in my MySQL database? I am using phpMyAdmin. From what I can see, it won't allow me to import that kind of file.

Any help is appreciated.


This is possible via phpMyAdmin.

Import a CSV-file, but replace the semicolon with the pipe |. Empty the input "Fields enclosed by" and check the box "Column names in first row".

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号