{"data":{"question_details":{"data":{"answers":[{"qid":"6720674944411238659","aid":"6720834027240030472","uid":"1411400776555838","uname":"阿七牛雜","avatar_url":"https://p1.toutiaoimg.com/img/mosaic-legacy/feb200003635626ff3bf~0x0.image","auth_info":"{\"auth_type\":\"3\",\"auth_info\":\"信息技術(shù)公司軟件工程師\"}","content":"\u003cp\u003e●首先需要在mysql管理工具上面新建一個表,也可以用mysql命令創(chuàng)建,表建立完成之后,需要將表中的字段名字告訴給填寫excel表的人員.●打開excel表,按照程序提供的字段填寫相應(yīng)的數(shù)據(jù).此時注意下面幾點:名字需要跟程序提供的一樣,其他的描述,表頭可以不寫都行.●打開工具,選擇表所在的數(shù)據(jù)庫,然后點擊數(shù)據(jù)庫名字,右鍵數(shù)據(jù),出來下拉菜單選擇import wizard .彈出一個選擇界面,選擇excel file文件●點擊next(下一步),選擇對應(yīng)的excel文件就行,然后再下面選在文件內(nèi)容在哪一個sheet中,也就是內(nèi)容寫在excel什么地方,這點需要注意,也是關(guān)鍵的地方.●點擊next (此步驟也是關(guān)鍵步驟),需要注意2點: \u003c/p\u003e\u003cp\u003e1:filed name row 就是字段所在excel中的位置,也就是第幾行(簡單辦法,一般就是英文對應(yīng)的那一列).\u003c/p\u003e\u003cp\u003e2:first data row(從哪一行開始執(zhí)行),數(shù)據(jù)從哪一行開始●點擊next 選擇 target table 目標(biāo)對應(yīng)的數(shù)據(jù)庫,選擇.●如果到上面一步?jīng)]有問題的話,默認(rèn)next到最后 就行了.然后打開表就能看到數(shù)據(jù)跟excel表中的一樣.要導(dǎo)入到哪個數(shù)據(jù)庫中表中\(zhòng)u003c/p\u003e","abstract":"●首先需要在mysql管理工具上面新建一...","create_time":1564816112,"update_time":1673989066,"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":"1673989066","propedit_review_visibility":"{\"prop_name\":\"review_visibility\",\"prop_value\":\"65\",\"editor\":\"toutiao.search_content.script\",\"reason_code\":0}","ugc_shark_decision":"{\"Decision\": \"PASS\", \"DecisionDetail\": \"\", \"HitStatus\": \"{}\"}","wd_activity_from":"answer_get_bonus","wd_source":"question_click_write_answer","wdh_client_ip":"132.232.103.158"},"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":25,"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":"6720674944411238659","title":"excel導(dǎo)入mysql數(shù)據(jù)庫？","content":"","pictures":null,"answer_count":1,"pv":679,"embrave":{"embrave_type":0,"integral_count":0,"gold_count":0,"reward_time":0},"create_time":1564779073,"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://sf6-cdn-tos.toutiaostatic.com/img/mosaic-legacy/1641/3396065671~300x300.image"},"extra":{"has_out_answer":"0","modify_time":"1674244988","propedit_review_visibility":"{\"prop_name\":\"review_visibility\",\"prop_value\":\"65\",\"editor\":\"toutiao.search_content.script\",\"reason_code\":0}","search_last_view_time":"1637251249","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":"202302092112340101501341671EC018D1","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=6720674944411238659&qname=excel導(dǎo)入mysql數(shù)據(jù)庫？&search_id=202302092112300101501341671EC018B4&enter_answer_id=6720834027240030472&outer_show_aid=6720834027240030472&query=mysql怎么導(dǎo)入數(shù)據(jù)庫","origin":"https://so.toutiao.com","pathname":"/s/search_wenda_pc/list/","port":"","protocol":"https:","search":"?enter_from=search_result&qid=6720674944411238659&qname=excel導(dǎo)入mysql數(shù)據(jù)庫？&search_id=202302092112300101501341671EC018B4&enter_answer_id=6720834027240030472&outer_show_aid=6720834027240030472&query=mysql怎么導(dǎo)入數(shù)據(jù)庫","username":"","password":""},"query":{"enter_from":"search_result","qid":"6720674944411238659","qname":"excel導(dǎo)入mysql數(shù)據(jù)庫？","search_id":"202302092112300101501341671EC018B4","enter_answer_id":"6720834027240030472","outer_show_aid":"6720834027240030472","query":"mysql怎么導(dǎo)入數(shù)據(jù)庫"},"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":"/"}}}