{"data":{"question_details":{"data":{"answers":[{"qid":"6804431927257334023","aid":"6847056917668970765","uid":"85496489150","uname":"胡梅雪670754","avatar_url":"https://sf1-cdn-tos.toutiaostatic.com/img/user-avatar/10c000bb0754743aca549886e791071f~300x300.image","auth_info":"","content":"\u003cp\u003e有多種方法.請參考以下方法.\u003c/p\u003e\u003cp\u003e方法一:\u003c/p\u003e\u003cp\u003e安裝一個mysql的客戶端,比如navicat,建好連接,打開要導入的數據庫,點擊導入向導,選擇要導入的 數據,選擇要導入的目標表,在最后的選項中選擇附加到已有數據.\u003c/p\u003e\u003cp\u003e方法二:\u003c/p\u003e\u003cp\u003e先使用mysq命令行導入新數據到一張新表,新表結構與之前表一樣.然后執行以下插入語句.\u003c/p\u003e\u003cp\u003e假定新表名為new_tb,原表名為old_tb,\u003c/p\u003e\u003cp\u003e則\u003c/p\u003e\u003cp\u003einsert into old_tb select * from new_tb\u003c/p\u003e","abstract":"有多種方法.請參考以下方法.方法一:安裝...","create_time":1594204687,"update_time":1673896224,"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":{"group_decay_type":"9","modify_time":"1673896224","propedit_review_visibility":"{\"prop_name\":\"review_visibility\",\"prop_value\":\"65\",\"confidence\":null,\"editor\":\"\",\"reason_code\":0,\"reason_message\":\"\",\"edit_time\":1603958898}","reviewed_level":"16","search_nice_answer":"1","ugc_shark_decision":"{\"Decision\":\"BLOCK\",\"DecisionDetail\":\"spam\",\"HitStatus\":\"{\\\"2092\\\":{\\\"decision\\\":\\\"MARK\\\",\\\"decision_detail\\\":\\\"\\\"},\\\"32691\\\":{\\\"decision\\\":\\\"BLOCK\\\",\\\"decision_detail\\\":\\\"spam\\\"},\\\"20069\\\":{\\\"decision\\\":\\\"MARK\\\",\\\"decision_detail\\\":\\\"\\\"},\\\"342\\\":{\\\"decision\\\":\\\"MARK\\\",\\\"decision_detail\\\":\\\"\\\"},\\\"8429\\\":{\\\"decision\\\":\\\"MARK\\\",\\\"decision_detail\\\":\\\"\\\"},\\\"17993\\\":{\\\"decision\\\":\\\"MARK\\\",\\\"decision_detail\\\":\\\"\\\"},\\\"18205\\\":{\\\"decision\\\":\\\"MARK\\\",\\\"decision_detail\\\":\\\"\\\"},\\\"23106\\\":{\\\"decision\\\":\\\"BLOCK\\\",\\\"decision_detail\\\":\\\"spam\\\"},\\\"26580\\\":{\\\"decision\\\":\\\"BLOCK\\\",\\\"decision_detail\\\":\\\"spam\\\"},\\\"44971\\\":{\\\"decision\\\":\\\"BLOCK\\\",\\\"decision_detail\\\":\\\"spam\\\"}}\"}","wd_activity_from":"answer_get_bonus","wd_source":"","wdh_client_ip":"119.45.41.225"},"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":24,"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":"6804431927257334023","title":"給mysql數據庫的某個表導入新數據，怎么才能不覆蓋原來的表呢，急？","content":"","pictures":null,"answer_count":1,"pv":318,"embrave":{"embrave_type":0,"integral_count":0,"gold_count":0,"reward_time":0},"create_time":1584280265,"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":"xiaodi1990","avatar_url":"https://sf1-cdn-tos.toutiaostatic.com/img/mosaic-legacy/4071/284485996~300x300.image"},"extra":{"group_decay_type":"9","has_nice_answer":"1","has_out_answer":"1","modify_time":"1673905382","propedit_review_visibility":"{\"prop_name\":\"review_visibility\",\"prop_value\":\"65\",\"editor\":\"toutiao.search_content.script\",\"reason_code\":0}","reviewed_level":"11","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":"202302092112360101501341671EC018E3","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=6804431927257334023&qname=給mysql數據庫的某個表導入新數據，怎么才能不覆蓋原來的表呢，急？&search_id=202302092112350101501341671EC018D9&enter_answer_id=6847056917668970765&outer_show_aid=6847056917668970765&query=mysql怎么導入數據庫","origin":"https://so.toutiao.com","pathname":"/s/search_wenda_pc/list/","port":"","protocol":"https:","search":"?enter_from=search_result&qid=6804431927257334023&qname=給mysql數據庫的某個表導入新數據，怎么才能不覆蓋原來的表呢，急？&search_id=202302092112350101501341671EC018D9&enter_answer_id=6847056917668970765&outer_show_aid=6847056917668970765&query=mysql怎么導入數據庫","username":"","password":""},"query":{"enter_from":"search_result","qid":"6804431927257334023","qname":"給mysql數據庫的某個表導入新數據，怎么才能不覆蓋原來的表呢，急？","search_id":"202302092112350101501341671EC018D9","enter_answer_id":"6847056917668970765","outer_show_aid":"6847056917668970765","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":"/"}}}