{"data":{"question_details":{"data":{"answers":[{"qid":"6680502212415717644","aid":"6685498408649621768","uid":"52041042980","uname":"IT極客老兵","avatar_url":"https://sf3-cdn-tos.toutiaostatic.com/img/mosaic-legacy/feaf0000a0e580cf015a~300x300.image","auth_info":"{\"auth_type\":\"0\",\"auth_info\":\"軟件公司技術總監 優質科技領域創作者\",\"other_auth\":{\"interest\":\"優質科技領域創作者\"}}","content":"\u003cp\u003emysqlimport 是操作系統命令，不需要登錄數據庫；\u003c/p\u003e\u003cp\u003esource需要登錄數據庫后執行。\u003c/p\u003e\u003cp\u003e導出數據結構是為了導出建庫建表命令sql，命令如下：\u003c/p\u003e\u003cp\u003emysqldump -hhostname -uusername -ppassword -d databasename > d:\\sql\\databasename.sql\u003c/p\u003e\u003cp\u003esource d:\\sql\\databasename.sql\u003c/p\u003e\u003cp\u003e即可導入數據庫結構，因為databasename.sql中只包含數據庫結構的sql語句。\u003c/p\u003e","abstract":"mysqlimport 是操作系統命令，不...","create_time":1556588897,"update_time":1674591432,"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_wukong":"1","group_decay_type":"9","modify_time":"1674591432","propedit_review_visibility":"{\"prop_name\":\"review_visibility\",\"prop_value\":\"65\",\"confidence\":11,\"editor\":\"content.online_cloud.flash_items\",\"reason_code\":0,\"reason_message\":null,\"edit_time\":null}","ugc_shark_decision":"{\"Decision\": \"PASS\", \"DecisionDetail\": \"\", \"HitStatus\": \"{\\\"2176\\\":{\\\"decision\\\":\\\"MARK\\\",\\\"decision_detail\\\":\\\"\\\"}}\"}","wd_source":"question_click_write_answer","wdh_client_ip":"127.0.0.1"},"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":true,"question":{"qid":"6680502212415717644","title":"mysql中的兩個導入命令的區別mysqlimport和source mysql的導出數據結構干什么用的？","content":"mysql中的兩個導入命令的區別mysqlimport和sourcemysql的導出數據結構干什么用的，怎么沒發現導入數據結構，就導入數據表和數據庫 ","pictures":null,"answer_count":1,"pv":1098,"embrave":{"embrave_type":0,"integral_count":0,"gold_count":0,"reward_time":0},"create_time":1555425630,"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/6786337672~300x300.image"},"extra":{"from_wukong":"1","has_out_answer":"2","modify_time":"1674081015","search_last_view_time":"1637239652","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":"202302092112330101501341671EC018CA","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=6680502212415717644&qname=mysql中的兩個導入命令的區別mysqlimport和source mysql的導出數據結構干什么用的？&search_id=202302092112300101501341671EC018B4&enter_answer_id=6685498408649621768&outer_show_aid=6685498408649621768&query=mysql怎么導入數據庫","origin":"https://so.toutiao.com","pathname":"/s/search_wenda_pc/list/","port":"","protocol":"https:","search":"?enter_from=search_result&qid=6680502212415717644&qname=mysql中的兩個導入命令的區別mysqlimport和source mysql的導出數據結構干什么用的？&search_id=202302092112300101501341671EC018B4&enter_answer_id=6685498408649621768&outer_show_aid=6685498408649621768&query=mysql怎么導入數據庫","username":"","password":""},"query":{"enter_from":"search_result","qid":"6680502212415717644","qname":"mysql中的兩個導入命令的區別mysqlimport和source mysql的導出數據結構干什么用的？","search_id":"202302092112300101501341671EC018B4","enter_answer_id":"6685498408649621768","outer_show_aid":"6685498408649621768","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":"/"}}}