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

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

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

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

{"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\":\"信息技术公司软件工程师\"}","content":"\u003cp\u003e●首先需要在mysql管理工具上面新建一个表,也可以用mysql命令创建,表建立完成之后,需要将表中的字段名字告诉给填写excel表的人员.●打开excel表,按照程序提供的字段填写相应的数据.此时注意下面几点:名字需要跟程序提供的一样,其他的描述,表头可以不写都行.●打开工具,选择表所在的数据库,然后点击数据库名字,右键数据,出来下拉菜单选择import wizard .弹出一个选择界面,选择excel file文件●点击next(下一步),选择对应的excel文件就行,然后再下面选在文件内容在哪一个sheet中,也就是内容写在excel什么地方,这点需要注意,也是关键的地方.●点击next (此步骤也是关键步骤),需要注意2点: \u003c/p\u003e\u003cp\u003e1:filed name row 就是字段所在excel中的位置,也就是第几行(简单办法,一般就是英文对应的那一列).\u003c/p\u003e\u003cp\u003e2:first data row(从哪一行开始执行),数据从哪一行开始●点击next 选择 target table 目标对应的数据库,选择.●如果到上面一步没有问题的话,默认next到最后 就行了.然后打开表就能看到数据跟excel表中的一样.要导入到哪个数据库中表中\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导入mysql数据库？","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导入mysql数据库？&search_id=202302092112300101501341671EC018B4&enter_answer_id=6720834027240030472&outer_show_aid=6720834027240030472&query=mysql怎么导入数据库","origin":"https://so.toutiao.com","pathname":"/s/search_wenda_pc/list/","port":"","protocol":"https:","search":"?enter_from=search_result&qid=6720674944411238659&qname=excel导入mysql数据库？&search_id=202302092112300101501341671EC018B4&enter_answer_id=6720834027240030472&outer_show_aid=6720834027240030472&query=mysql怎么导入数据库","username":"","password":""},"query":{"enter_from":"search_result","qid":"6720674944411238659","qname":"excel导入mysql数据库？","search_id":"202302092112300101501341671EC018B4","enter_answer_id":"6720834027240030472","outer_show_aid":"6720834027240030472","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":"/"}}}