专业网站建设品牌，十四年专业建站经验，服务6000+客户--广州京杭网络

免费热线：400-683-0016      微信咨询  |  联系我们

• 网站首页
• 网站建设
• 短视频
• 网站推广
• 网站模板
• 客户案例
• 资讯动态
• 关于我们

当前位置：网站建设 > 技术支持

{"data":{"question_details":{"data":{"answers":[{"qid":"6723591568617373966","aid":"6724551408470720781","uid":"92201346490","uname":"小小猿爱嘻嘻","avatar_url":"https://p9.toutiaoimg.com/img/mosaic-legacy/fe5e00001245e2b4e4f9~0x0.image","auth_info":"{\"auth_type\":\"0\",\"auth_info\":\"优质科技领域创作者\",\"other_auth\":{\"interest\":\"优质科技领域创作者\"}}","content":"\u003cp\u003eTXT文件数据导入MySQL数据库，目前来说，有2种方式，一种是命令行导入，一种是借助客户端软件导入，下面我简单介绍一下，感兴趣的朋友可以操作一下，都非常容易：\u003c/p\u003e\u003cp\u003e为了更好的说明问题，这里假设导入的TXT文件数据如下，每行4列，每列之间使用Tab键进行分隔（也可以是其他分隔符，像逗号、分号等，影响不大）：\u003c/p\u003e\u003cp\u003e\u003cimg src=\"https://p3.douyinpic.com/large/2b28500006cbb4032dcc5\" height=\"232\" width=\"460\" /\u003e\u003c/p\u003e\u003cp\u003e命令行导入\u003c/p\u003e\u003cp\u003e这种方式最基本也最简单，需要先手动创建一个对应的数据表（和TXT文件数据格式保持一致），然后加载本地TXT文件（这里需要去掉TXT文件开始的标题行），最后再直接插入到数据表中，截图如下，这里MySQL数据库默认会按照Tab进行分割，如果是其他分隔符的话，可以使用fields terminated by关键字指定，逗号的话，是fields terminated by ','，分号是fields terminated by ';'，非常容易：\u003c/p\u003e\u003cp\u003e\u003cimg src=\"https://p3.douyinpic.com/large/174f40007f256cc5325b4\" height=\"458\" width=\"630\" /\u003e\u003c/p\u003e\u003cp\u003e客户端软件导入\u003c/p\u003e\u003cp\u003e1.以Navicat MySQL客户端软件为例，双击打开对应数据库，右键“表”，选择“导入向导”，如下：\u003cbr/\u003e\u003c/p\u003e\u003cp\u003e\u003cimg src=\"https://p3.douyinpic.com/large/2b287000039331e3583d3\" height=\"282\" width=\"465\" /\u003e\u003c/p\u003e\u003cp\u003e2.接着在弹出的导入对话框中选择“文本文件(.txt)”，点击下一步，选择需要导入的TXT文件，这时就可以指定列分隔符了，可以是分号、逗号、空格等，根据实际TXT文本格式选择对应分隔符即可，如下：\u003c/p\u003e\u003cp\u003e\u003cimg src=\"https://p3.douyinpic.com/large/174f80007ee3629a95b42\" height=\"254\" width=\"519\" /\u003e\u003c/p\u003e\u003cp\u003e3.点击下一步按钮，进入附加选项，这里可以设置栏名（字段名）、数据、日期等，以上面测试数据为例，第1行是栏名，第2行开始才是真正数据：\u003c/p\u003e\u003cp\u003e\u003cimg src=\"https://p3.douyinpic.com/large/2b2910000680ea0e250f2\" height=\"294\" width=\"517\" /\u003e\u003c/p\u003e\u003cp\u003e4.最后再检查一下导入的结构是否合理，这里可以对相应字段进行设置，包括调整类型、长度，设置主键等，一切配置完成后，直接点击右下角开始按钮即可导入：\u003c/p\u003e\u003cp\u003e\u003cimg src=\"https://p3.douyinpic.com/large/174f60007ef31d58b2505\" height=\"261\" width=\"520\" /\u003e\u003c/p\u003e\u003cp\u003e成功导入后的数据如下，和TXT文本数据一致：\u003c/p\u003e\u003cp\u003e\u003cimg src=\"https://p3.douyinpic.com/large/2b28600006c0493d288b3\" height=\"224\" width=\"468\" /\u003e\u003c/p\u003e\u003cp\u003e至此，我们就完成了将TXT文件数据导入到MySQL数据库中。总的来说，整个过程非常简单，第一种方式最简单也最基本，先加载TXT文件，然后直接插入数据表即可，第二种方式借助客户端软件，手动导入，也非常容易，只要你熟悉一下上面的操作过程，很快就能掌握的，网上也有相关教程和资料，介绍的非常详细，感兴趣的话，可以搜一下，希望以上分享的内容能对你有所帮助吧，也欢迎大家评论、留言进行补充。\u003c/p\u003e","abstract":"TXT文件数据导入MySQL数据库，目前...","create_time":1565681633,"update_time":1674205543,"digg_info":{"digg_count":0,"own_digg":false,"digg_list":null},"comment_info":{"comment_count":15},"repost_info":{"repost_count":14},"audit_info":{"audit_status":-1,"audit_status_msg":"","audit_status_msg_desc":""},"pv":0,"vl":69,"content_with_entity":"","extra":{"from_wukong":"1","group_decay_type":"9","modify_time":"1674205543","propedit_review_visibility":"{\"prop_name\":\"review_visibility\",\"prop_value\":\"69\",\"confidence\":11,\"editor\":\"content.online_cloud.flash_items\",\"reason_code\":0,\"reason_message\":null,\"edit_time\":null}","ugc_shark_decision":"{\"Decision\": \"PASS\", \"DecisionDetail\": \"\", \"HitStatus\": \"\"}","wd_source":"question_click_write_answer","wdh_client_ip":"124.115.236.17"},"integral_order_list":null,"integral_count":0,"bury_info":{"bury_count":0,"own_bury":false},"sent_flower_status":0,"could_show_flower_text":false,"author_digg_count":6,"author_show_digg_status":false,"ban_comment":false,"relation_info":{"is_following":false},"user_status":{"is_cancelled":false,"is_banned":false},"feedback_user_not_acted_aid":true,"help_info":{"is_helpful_count":0,"own_is_helpful":false}}],"has_more":false,"question":{"qid":"6723591568617373966","title":"如何把TXT文件数据导入MySQL数据库？","content":"","pictures":null,"answer_count":1,"pv":834,"embrave":{"embrave_type":0,"integral_count":0,"gold_count":0,"reward_time":0},"create_time":1565458153,"vl":60,"audit_info":{"audit_status":2,"audit_status_msg":"","audit_status_msg_desc":""},"new_answer_cnt":0,"question_belong_status":2,"user_info":{"uid":"","uname":"lovetankai","avatar_url":"https://sf6-cdn-tos.toutiaostatic.com/img/mosaic-legacy/8611/3543154901~300x300.image"},"extra":{"from_wukong":"1","has_out_answer":"0","modify_time":"1674660744","wdh_client_ip":"127.0.0.1"},"img_q_integral":0,"feedback_user_not_answered":true,"feedback_user_not_acted":true},"rank1_could_show_flower_text":false,"contentType":"application/json; charset=utf-8","fontStyle":{"domains":["tosv.boe.byted.org"],"filename":"","base64":[],"fontKey":"","tosSuffix":""},"fontKey":"","fontStyleString":""},"errcode":0,"errmsg":"success"},"login_info":{"data":{"is_answered":1,"is_new":true,"uid":"","user_info":{"uid":"","uname":"","avatar_url":""}},"errcode":0,"errmsg":"success"}},"commonData":{"isSsrFrame":true,"ttLogId":"202302092112290101501341671EC018AB","location":{"hash":"","host":"so.toutiao.com","hostname":"so.toutiao.com","href":"https://so.toutiao.com/s/search_wenda_pc/list/?enter_from=search_result&qid=6723591568617373966&qname=如何把TXT文件数据导入MySQL数据库？&search_id=202302092112280101501341671EC018A1&enter_answer_id=6724551408470720781&outer_show_aid=6724551408470720781&query=mysql怎么导入数据库","origin":"https://so.toutiao.com","pathname":"/s/search_wenda_pc/list/","port":"","protocol":"https:","search":"?enter_from=search_result&qid=6723591568617373966&qname=如何把TXT文件数据导入MySQL数据库？&search_id=202302092112280101501341671EC018A1&enter_answer_id=6724551408470720781&outer_show_aid=6724551408470720781&query=mysql怎么导入数据库","username":"","password":""},"query":{"enter_from":"search_result","qid":"6723591568617373966","qname":"如何把TXT文件数据导入MySQL数据库？","search_id":"202302092112280101501341671EC018A1","enter_answer_id":"6724551408470720781","outer_show_aid":"6724551408470720781","query":"mysql怎么导入数据库"},"client":{"width":1920,"height":880,"pixelRatio":1,"userAgent":"Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.198 Safari/537.36","isPC":true,"platform":"windows"},"serverEnv":"production","abFields":{},"user":{"webId":"7167564658018354696"},"isRPC":false,"params":{},"env":{"isBOE":false,"isProd":true,"isPPE":false,"cluster":"default"},"routingInfos":{"tc":"search_wenda_pc","business_path":"/list","routing_path":"/"}}}