{"data":{"question_details":{"data":{"answers":[{"qid":"6731460551555154188","aid":"6732007273918382349","uid":"1789621041374356","uname":"他就問我愛口袋","avatar_url":"https://sf1-cdn-tos.toutiaostatic.com/img/tos-cn-i-0022/5b144554bd314d1ab2762dcb4e363d55~300x300.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":"3320140860230667","uname":"用戶2815281292568","avatar_url":"https://p9-passport.byteacctimg.com/img/mosaic-legacy/3795/3044413937~300x300.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-tos.toutiaostatic.com/img/mosaic-legacy/4066/6949608908~300x300.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.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":"202302092112490101501341671EC01961","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=6731460551555154188&qname=如何將excel表格導入mysql數據庫？&search_id=202302092112460101501341671EC0193F&enter_answer_id=6732007273918382349&outer_show_aid=6732007273918382349&query=mysql怎么導入數據庫","origin":"https://so.toutiao.com","pathname":"/s/search_wenda_pc/list/","port":"","protocol":"https:","search":"?enter_from=search_result&qid=6731460551555154188&qname=如何將excel表格導入mysql數據庫？&search_id=202302092112460101501341671EC0193F&enter_answer_id=6732007273918382349&outer_show_aid=6732007273918382349&query=mysql怎么導入數據庫","username":"","password":""},"query":{"enter_from":"search_result","qid":"6731460551555154188","qname":"如何將excel表格導入mysql數據庫？","search_id":"202302092112460101501341671EC0193F","enter_answer_id":"6732007273918382349","outer_show_aid":"6732007273918382349","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":"/"}}}