{“data”:{“question_details”:{“data”:{“answers”:[{“qid”:”6731460551555154188″,”aid”:”673273918382349″,”uid”:”1789621041374356″,”uname”:”他就问偶爱口袋”,”avatar_url”:”https://sf1-cdn-/img/tos-cn-i-0022/5b144554bd314d1ab2762dcb4e363d55~300×300.image”,”auth_info”:””,”content”:”\u003cp\u003e导入步骤如下：\u003c/p\u003e\u003cp\u003e1.将选中的数据快儿拷贝到一个TXT文本文件中（记得把后面的空格消掉。否则导入数据库后会有对应的空行），假如存到“D:\\data.txt”这个位置里。\u003c/p\u003e\u003cp\u003e2.根据要导入的数据快儿建立MySql数据库和表，然后进入命令提示符里使用命令load data local infile ‘D:/data.txt’ into table exceltomysql fields terminated by ‘\\t’;注意：盘符偶使用的“/”才成功，否则提示找不到文件 下面文章中是用的“\\”！进行导入操作手动进行Excel数据和MySql数据转换\u003c/p\u003e”,”abstract”:”导入步骤如下：1.将选中的数据快儿拷贝到…”,”create_time”:1567417587,”update_time”:1674504228,”digg_info”:{“digg_count”:0,”own_digg”:false,”digg_list”:null},”comment_info”:{“comment_count”:0},”repost_info”:{“repost_count”:0},”audit_info”:{“audit_status”:-1,”audit_status_msg”:””,”audit_status_msg_desc”:””},”pv”:0,”vl”:65,”content_with_entity”:””,”extra”:{“modify_time”:”1674504228″,”propedit_review_visibility”:”{\”prop_name\”:\”review_visibility\”,\”prop_value\”:\”65\”,\”editor\”:\”toutiao.search_content.script\”,\”reason_code\”:0}”,”search_nice_answer”:”1″,”ugc_shark_decision”:”{\”Decision\”: \”BLOCK\”, \”DecisionDetail\”: \”reject\”, \”HitStatus\”: \”{\\\”20594\\\”:{\\\”decision\\\”:\\\”BLOCK\\\”,\\\”decision_detail\\\”:\\\”reject\\\”},\\\”20647\\\”:{\\\”decision\\\”:\\\”BLOCK\\\”,\\\”decision_detail\\\”:\\\”{\\\\\\\”from\\\\\\\”:\\\\\\\”shark_admin\\\\\\\”,\\\\\\\”type\\\\\\\”:\\\\\\\”verify\\\\\\\”,\\\\\\\”subtype\\\\\\\”:\\\\\\\”slide\\\\\\\”,\\\\\\\”detail\\\\\\\”:{\\\\\\\”punish_duration\\\\\\\”:60,\\\\\\\”exempt_duration\\\\\\\”:1800}}\\\”},\\\”9709\\\”:{\\\”decision\\\”:\\\”MARK\\\”,\\\”decision_detail\\\”:\\\”\\\”},\\\”26580\\\”:{\\\”decision\\\”:\\\”BLOCK\\\”,\\\”decision_detail\\\”:\\\”{\\\\\\\”from\\\\\\\”:\\\\\\\”shark_admin\\\\\\\”,\\\\\\\”type\\\\\\\”:\\\\\\\”verify\\\\\\\”,\\\\\\\”subtype\\\\\\\”:\\\\\\\”slide\\\\\\\”,\\\\\\\”detail\\\\\\\”:{\\\\\\\”punish_duration\\\\\\\”:60,\\\\\\\”exempt_duration\\\\\\\”:1800}}\\\”},\\\”23698\\\”:{\\\”decision\\\”:\\\”BLOCK\\\”,\\\”decision_detail\\\”:\\\”{\\\\\\\”from\\\\\\\”:\\\\\\\”shark_admin\\\\\\\”,\\\\\\\”type\\\\\\\”:\\\\\\\”verify\\\\\\\”,\\\\\\\”subtype\\\\\\\”:\\\\\\\”slide\\\\\\\”,\\\\\\\”detail\\\\\\\”:{\\\\\\\”punish_duration\\\\\\\”:60,\\\\\\\”exempt_duration\\\\\\\”:1800}}\\\”},\\\”19688\\\”:{\\\”decision\\\”:\\\”MARK\\\”,\\\”decision_detail\\\”:\\\”\\\”},\\\”1071\\\”:{\\\”decision\\\”:\\\”MARK\\\”,\\\”decision_detail\\\”:\\\”\\\”},\\\”20648\\\”:{\\\”decision\\\”:\\\”BLOCK\\\”,\\\”decision_detail\\\”:\\\”{\\\\\\\”from\\\\\\\”:\\\\\\\”shark_admin\\\\\\\”,\\\\\\\”type\\\\\\\”:\\\\\\\”verify\\\\\\\”,\\\\\\\”subtype\\\\\\\”:\\\\\\\”slide\\\\\\\”,\\\\\\\”detail\\\\\\\”:{\\\\\\\”punish_duration\\\\\\\”:60,\\\\\\\”exempt_duration\\\\\\\”:1800}}\\\”},\\\”18205\\\”:{\\\”decision\\\”:\\\”MARK\\\”,\\\”decision_detail\\\”:\\\”\\\”},\\\”5017\\\”:{\\\”decision\\\”:\\\”MARK\\\”,\\\”decision_detail\\\”:\\\”\\\”},\\\”23029\\\”:{\\\”decision\\\”:\\\”BLOCK\\\”,\\\”decision_detail\\\”:\\\”reject\\\”}}\”}”,”wd_activity_from”:”answer_get_bonus”,”wd_source”:”question_click_write_answer”,”wdh_client_ip”:”39.154.200.145″},”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”:0,”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}},{“qid”:”6731460551555154188″,”aid”:”6732985907617464583″,”uid”:”330860230667″,”uname”:”用户2815281292568″,”avatar_url”:”https://p9-/img/mosaic-legacy/3795/3044413937~300×300.image”,”auth_info”:””,”content”:”\u003cp\u003emysql 有load data infile 语法可以直接把文件中的数据导入数据库。\u003c/p\u003e\u003cp\u003e去重的话你是跨文件去重？还是单个文件内去重？\u003c/p\u003e\u003cp\u003e跨文件去重的话，又要高效又要去重，做不到。\u003c/p\u003e\u003cp\u003e单个文件去重的话，不知道load data infile 语法能否支持，偶没试过。\u003c/p\u003e\u003cp\u003e可以先入库在去重，效率应该会高些。\u003c/p\u003e”,”abstract”:”mysql 有load data inf…”,”create_time”:1567645442,”update_time”:1674190705,”digg_info”:{“digg_count”:0,”own_digg”:false,”digg_list”:null},”comment_info”:{“comment_count”:0},”repost_info”:{“repost_count”:0},”audit_info”:{“audit_status”:-1,”audit_status_msg”:””,”audit_status_msg_desc”:””},”pv”:0,”vl”:65,”content_with_entity”:””,”extra”:{“modify_time”:”1674190705″,”propedit_review_visibility”:”{\”prop_name\”:\”review_visibility\”,\”prop_value\”:\”65\”,\”editor\”:\”toutiao.search_content.script\”,\”reason_code\”:0}”,”ugc_shark_decision”:”{\”Decision\”: \”BLOCK\”, \”DecisionDetail\”: \”reject\”, \”HitStatus\”: \”{\\\”20594\\\”:{\\\”decision\\\”:\\\”BLOCK\\\”,\\\”decision_detail\\\”:\\\”reject\\\”},\\\”9709\\\”:{\\\”decision\\\”:\\\”MARK\\\”,\\\”decision_detail\\\”:\\\”\\\”},\\\”23027\\\”:{\\\”decision\\\”:\\\”BLOCK\\\”,\\\”decision_detail\\\”:\\\”reject\\\”},\\\”7321\\\”:{\\\”decision\\\”:\\\”MARK\\\”,\\\”decision_detail\\\”:\\\”\\\”},\\\”19688\\\”:{\\\”decision\\\”:\\\”MARK\\\”,\\\”decision_detail\\\”:\\\”\\\”},\\\”20648\\\”:{\\\”decision\\\”:\\\”BLOCK\\\”,\\\”decision_detail\\\”:\\\”{\\\\\\\”from\\\\\\\”:\\\\\\\”shark_admin\\\\\\\”,\\\\\\\”type\\\\\\\”:\\\\\\\”verify\\\\\\\”,\\\\\\\”subtype\\\\\\\”:\\\\\\\”slide\\\\\\\”,\\\\\\\”detail\\\\\\\”:{\\\\\\\”punish_duration\\\\\\\”:60,\\\\\\\”exempt_duration\\\\\\\”:1800}}\\\”},\\\”23026\\\”:{\\\”decision\\\”:\\\”BLOCK\\\”,\\\”decision_detail\\\”:\\\”reject\\\”},\\\”5017\\\”:{\\\”decision\\\”:\\\”MARK\\\”,\\\”decision_detail\\\”:\\\”\\\”},\\\”1071\\\”:{\\\”decision\\\”:\\\”MARK\\\”,\\\”decision_detail\\\”:\\\”\\\”},\\\”18205\\\”:{\\\”decision\\\”:\\\”MARK\\\”,\\\”decision_detail\\\”:\\\”\\\”},\\\”26580\\\”:{\\\”decision\\\”:\\\”BLOCK\\\”,\\\”decision_detail\\\”:\\\”{\\\\\\\”from\\\\\\\”:\\\\\\\”shark_admin\\\\\\\”,\\\\\\\”type\\\\\\\”:\\\\\\\”verify\\\\\\\”,\\\\\\\”subtype\\\\\\\”:\\\\\\\”slide\\\\\\\”,\\\\\\\”detail\\\\\\\”:{\\\\\\\”punish_duration\\\\\\\”:60,\\\\\\\”exempt_duration\\\\\\\”:1800}}\\\”},\\\”23029\\\”:{\\\”decision\\\”:\\\”BLOCK\\\”,\\\”decision_detail\\\”:\\\”reject\\\”},\\\”23698\\\”:{\\\”decision\\\”:\\\”BLOCK\\\”,\\\”decision_detail\\\”:\\\”{\\\\\\\”from\\\\\\\”:\\\\\\\”shark_admin\\\\\\\”,\\\\\\\”type\\\\\\\”:\\\\\\\”verify\\\\\\\”,\\\\\\\”subtype\\\\\\\”:\\\\\\\”slide\\\\\\\”,\\\\\\\”detail\\\\\\\”:{\\\\\\\”punish_duration\\\\\\\”:60,\\\\\\\”exempt_duration\\\\\\\”:1800}}\\\”}}\”}”,”wd_activity_from”:”answer_get_bonus”,”wd_source”:”question_click_write_answer”,”wdh_client_ip”:”144.0.163.122″},”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”:0,”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”:”6731460551555154188″,”title”:”如何将excel表格导入mysql数据库？”,”content”:””,”pictures”:null,”answer_count”:2,”pv”:828,”embrave”:{“embrave_type”:0,”integral_count”:0,”gold_count”:0,”reward_time”:0},”create_time”:1567290293,”vl”:65,”audit_info”:{“audit_status”:2,”audit_status_msg”:””,”audit_status_msg_desc”:””},”new_answer_cnt”:0,”question_belong_status”:2,”user_info”:{“uid”:””,”uname”:”爱老歌的人”,”avatar_url”:”https://sf3-cdn-/img/mosaic-legacy/4066/6949608908~300×300.image”},”extra”:{“has_nice_answer”:”1″,”has_out_answer”:”2″,”modify_time”:”1674446669″,”propedit_review_visibility”:”{\”prop_name\”:\”review_visibility\”,\”prop_value\”:\”65\”,\”editor\”:\”toutiao.search_content.script\”,\”reason_code\”:0}”,”search_last_view_time”:”1637251380″,”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.”],”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”:”02092112490101501341671EC01961″,”location”:{“hash”:””,”host”:””,”hostname”:””,”href”:”/s/search_wenda_pc/list/?enter_from=search_result&qid=6731460551555154188&qname=如何将excel表格导入mysql数据库？&search_id=02092112460101501341671EC0193F&enter_answer_id=673273918382349&outer_show_aid=673273918382349&query=mysql怎么导入数据库”,”origin”:””,”pathname”:”/s/search_wenda_pc/list/”,”port”:””,”protocol”:”https:”,”search”:”?enter_from=search_result&qid=6731460551555154188&qname=如何将excel表格导入mysql数据库？&search_id=02092112460101501341671EC0193F&enter_answer_id=673273918382349&outer_show_aid=673273918382349&query=mysql怎么导入数据库”,”username”:””,”password”:””},”query”:{“enter_from”:”search_result”,”qid”:”6731460551555154188″,”qname”:”如何将excel表格导入mysql数据库？”,”search_id”:”02092112460101501341671EC0193F”,”enter_answer_id”:”673273918382349″,”outer_show_aid”:”673273918382349″,”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”:”/”}}}
