资料来源:网络整理
时间:2023/3/9 2:00:00 共计:3563 浏览
{"data":{"question_details":{"data":{"answers":[{"qid":"6756242888897593613","aid":"6756244104524333326","uid":"4252543551281596","uname":"用户4252543551281596","avatar_url":"https://sf1-cdn-tos.toutiaostatic.com/img/user-avatar/7c4bf3f97697cc6cdf5d4e248998820a~300x300.image","auth_info":"","content":"\u003cp\u003e使用mysql管理工具,例如:Navicat for MySQL>打开工具,选择表所在的数据库,然后点击数据库名字,右键数据,出来下拉菜单选择import wizard ,有汉化版本的更明确.弹出一个选择界面,我们选择excel file文件,点击next(下一步),我们选择我们对应的excel文件就行 \u003c/p\u003e","abstract":"使用mysql管理工具,例如:Navic...","create_time":1573060663,"update_time":1674687583,"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":{"from_spam_user":"1","modify_time":"1674687583","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\": \"{\\\"27705\\\":{\\\"decision\\\":\\\"BLOCK\\\",\\\"decision_detail\\\":\\\"reject\\\"},\\\"23106\\\":{\\\"decision\\\":\\\"BLOCK\\\",\\\"decision_detail\\\":\\\"reject\\\"},\\\"23025\\\":{\\\"decision\\\":\\\"MARK\\\",\\\"decision_detail\\\":\\\"\\\"},\\\"6832\\\":{\\\"decision\\\":\\\"MARK\\\",\\\"decision_detail\\\":\\\"\\\"},\\\"20647\\\":{\\\"decision\\\":\\\"BLOCK\\\",\\\"decision_detail\\\":\\\"{\\\\\\\"from\\\\\\\":\\\\\\\"shark_admin\\\\\\\",\\\\\\\"type\\\\\\\":\\\\\\\"verify\\\\\\\",\\\\\\\"subtype\\\\\\\":\\\\\\\"slide\\\\\\\",\\\\\\\"detail\\\\\\\":{\\\\\\\"punish_duration\\\\\\\":60,\\\\\\\"exempt_duration\\\\\\\":1800}}\\\"},\\\"5017\\\":{\\\"decision\\\":\\\"MARK\\\",\\\"decision_detail\\\":\\\"\\\"},\\\"19684\\\":{\\\"decision\\\":\\\"MARK\\\",\\\"decision_detail\\\":\\\"\\\"},\\\"27082\\\":{\\\"decision\\\":\\\"MARK\\\",\\\"decision_detail\\\":\\\"\\\"},\\\"19688\\\":{\\\"decision\\\":\\\"MARK\\\",\\\"decision_detail\\\":\\\"\\\"},\\\"26580\\\":{\\\"decision\\\":\\\"BLOCK\\\",\\\"decision_detail\\\":\\\"{\\\\\\\"from\\\\\\\":\\\\\\\"shark_admin\\\\\\\",\\\\\\\"type\\\\\\\":\\\\\\\"verify\\\\\\\",\\\\\\\"subtype\\\\\\\":\\\\\\\"slide\\\\\\\",\\\\\\\"detail\\\\\\\":{\\\\\\\"punish_duration\\\\\\\":60,\\\\\\\"exempt_duration\\\\\\\":1800}}\\\"},\\\"30021\\\":{\\\"decision\\\":\\\"BLOCK\\\",\\\"decision_detail\\\":\\\"reject\\\"},\\\"18205\\\":{\\\"decision\\\":\\\"MARK\\\",\\\"decision_detail\\\":\\\"\\\"},\\\"2370\\\":{\\\"decision\\\":\\\"MARK\\\",\\\"decision_detail\\\":\\\"\\\"},\\\"27968\\\":{\\\"decision\\\":\\\"BLOCK\\\",\\\"decision_detail\\\":\\\"reject\\\"},\\\"23026\\\":{\\\"decision\\\":\\\"BLOCK\\\",\\\"decision_detail\\\":\\\"reject\\\"},\\\"1071\\\":{\\\"decision\\\":\\\"MARK\\\",\\\"decision_detail\\\":\\\"\\\"},\\\"20648\\\":{\\\"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":"121.230.46.23"},"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":189,"author_show_digg_status":true,"ban_comment":false,"relation_info":{"is_following":false},"user_status":{"is_cancelled":false,"is_banned":true},"feedback_user_not_acted_aid":true,"help_info":{"is_helpful_count":0,"own_is_helpful":false}}],"has_more":false,"question":{"qid":"6756242888897593613","title":"怎么把excel一列导入mysql数据库?","content":"","pictures":null,"answer_count":1,"pv":170,"embrave":{"embrave_type":0,"integral_count":0,"gold_count":0,"reward_time":0},"create_time":1573060380,"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":"Z-jane","avatar_url":"https://sf6-cdn-tos.toutiaostatic.com/img/mosaic-legacy/4070/881912552~300x300.image"},"extra":{"has_nice_answer":"1","has_out_answer":"1","modify_time":"1674553904","need_reproduce_spam_qid":"1","propedit_review_visibility":"{\"prop_name\":\"review_visibility\",\"prop_value\":\"65\",\"editor\":\"toutiao.search_content.script\",\"reason_code\":0}","search_last_view_time":"1637251396","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":"202302092112400101501341671EC018FD","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=6756242888897593613&qname=怎么把excel一列导入mysql数据库?&search_id=202302092112350101501341671EC018D9&enter_answer_id=6756244104524333326&outer_show_aid=6756244104524333326&query=mysql怎么导入数据库","origin":"https://so.toutiao.com","pathname":"/s/search_wenda_pc/list/","port":"","protocol":"https:","search":"?enter_from=search_result&qid=6756242888897593613&qname=怎么把excel一列导入mysql数据库?&search_id=202302092112350101501341671EC018D9&enter_answer_id=6756244104524333326&outer_show_aid=6756244104524333326&query=mysql怎么导入数据库","username":"","password":""},"query":{"enter_from":"search_result","qid":"6756242888897593613","qname":"怎么把excel一列导入mysql数据库?","search_id":"202302092112350101501341671EC018D9","enter_answer_id":"6756244104524333326","outer_show_aid":"6756244104524333326","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":"/"}}}
版权说明:
本网站凡注明“广州京杭 原创”的皆为本站原创文章,如需转载请注明出处!
本网转载皆注明出处,遵循行业规范,如发现作品内容版权或其它问题的,请与我们联系处理!
欢迎扫描右侧微信二维码与我们联系。