{"data":{"question_details":{"data":{"answers":[{"qid":"6685026983241318659","aid":"6689076734060396811","uid":"373477736986669","uname":"用戶6112904318325","avatar_url":"https://p9-passport.byteacctimg.com/img/mosaic-legacy/3793/3131589739~300x300.image","auth_info":"","content":"\u003cp\u003eysql自己有個csv引擎，可以通過這個引擎來實現將csv中的數據導入到mysql數據庫中，并且速度比通過php或是python寫的批處理程序快的多。\u003c/p\u003e\u003cp\u003e具體的實現代碼示例：\u003c/p\u003e\u003cp\u003e\u003c/p\u003e\u003cp\u003e代碼如下:\u003c/p\u003e\u003cp\u003e\u003c/p\u003e\u003cp\u003eload data infile '/tmp/file.csv' into table _tablename (set character utf8)\u003c/p\u003e\u003cp\u003efields terminated by ','\u003c/p\u003e\u003cp\u003eenclosed by '\"'\u003c/p\u003e\u003cp\u003elines terminated by '\\r\\n';\u003c/p\u003e\u003cp\u003e\u003c/p\u003e\u003cp\u003e這段代碼中涉及的一些關鍵字的解釋如下：\u003c/p\u003e\u003cp\u003efields terminated by '':這是指出csv文件中字段終止符，也就是數據之間的分隔符；\u003c/p\u003e\u003cp\u003eenclosed by '':指出封套符；\u003c/p\u003e\u003cp\u003elines terminated by '':指行終止符\u003c/p\u003e\u003cp\u003e在csv文檔（RFC4180）中詳細介紹了csv的格式，其中的要點有：\u003c/p\u003e\u003cp\u003e（1）字段之間以“，”（逗號）間隔，數據行之間使用\\r\\n分隔；\u003c/p\u003e\u003cp\u003e（2）字符串以半角雙引號包圍，字符串本身的雙引號用兩個雙引號表示。\u003c/p\u003e\u003cp\u003e通過以上的解釋，詳細對于數據導入代碼應該有更好的理解了。\u003c/p\u003e\u003cp\u003e同樣的，csv數據能夠導入mysql數據庫中，mysql中的數據表也能導出csv文件，導出的代碼示例：\u003c/p\u003e\u003cp\u003e\u003c/p\u003e\u003cp\u003e代碼如下:\u003c/p\u003e\u003cp\u003e\u003c/p\u003e\u003cp\u003eselect * from tablename into outfile '/tmp/data.txt'\u003c/p\u003e\u003cp\u003efields terminated by ','\u003c/p\u003e\u003cp\u003eoptionally enclosed by '\"'\u003c/p\u003e\u003cp\u003elines terminated by '\\n';\u003c/p\u003e\u003cp\u003e\u003c/p\u003e\u003cp\u003e當將數據庫中的數據導出到文件后，要再將數據導入到數據庫中，必須遵守導出時的文件中定義的格式。\u003c/p\u003e","abstract":"ysql自己有個csv引擎，可以通過這個...","create_time":1557422041,"update_time":1674248795,"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":"1674248795","ugc_shark_decision":"{\"Decision\": \"BLOCK\", \"DecisionDetail\": \"\", \"HitStatus\": \"{\\\"11194\\\":{\\\"decision\\\":\\\"MARK\\\",\\\"decision_detail\\\":\\\"\\\"},\\\"7321\\\":{\\\"decision\\\":\\\"BLOCK\\\",\\\"decision_detail\\\":\\\"\\\"},\\\"9759\\\":{\\\"decision\\\":\\\"MARK\\\",\\\"decision_detail\\\":\\\"\\\"},\\\"9709\\\":{\\\"decision\\\":\\\"MARK\\\",\\\"decision_detail\\\":\\\"\\\"},\\\"6832\\\":{\\\"decision\\\":\\\"MARK\\\",\\\"decision_detail\\\":\\\"\\\"},\\\"19688\\\":{\\\"decision\\\":\\\"MARK\\\",\\\"decision_detail\\\":\\\"\\\"},\\\"2176\\\":{\\\"decision\\\":\\\"MARK\\\",\\\"decision_detail\\\":\\\"\\\"},\\\"20069\\\":{\\\"decision\\\":\\\"MARK\\\",\\\"decision_detail\\\":\\\"\\\"},\\\"20070\\\":{\\\"decision\\\":\\\"MARK\\\",\\\"decision_detail\\\":\\\"\\\"}}\"}","wd_activity_from":"answer_get_bonus","wd_source":"question_click_write_answer","wdh_client_ip":"42.52.192.125"},"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":1,"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":"6685026983241318659","title":"怎么往mysql數據庫中導入csv數據？","content":"","pictures":null,"answer_count":1,"pv":683,"embrave":{"embrave_type":0,"integral_count":0,"gold_count":0,"reward_time":0},"create_time":1556479135,"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":"CJ-J","avatar_url":"https://sf1-cdn-tos.toutiaostatic.com/img/mosaic-legacy/8615/1609560811~300x300.image"},"extra":{"from_wukong":"1","modify_time":"1674660492","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":"202302092112490101501341671EC0196B","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=6685026983241318659&qname=怎么往mysql數據庫中導入csv數據？&search_id=202302092112460101501341671EC0193F&enter_answer_id=6689076734060396811&outer_show_aid=6689076734060396811&query=mysql怎么導入數據庫","origin":"https://so.toutiao.com","pathname":"/s/search_wenda_pc/list/","port":"","protocol":"https:","search":"?enter_from=search_result&qid=6685026983241318659&qname=怎么往mysql數據庫中導入csv數據？&search_id=202302092112460101501341671EC0193F&enter_answer_id=6689076734060396811&outer_show_aid=6689076734060396811&query=mysql怎么導入數據庫","username":"","password":""},"query":{"enter_from":"search_result","qid":"6685026983241318659","qname":"怎么往mysql數據庫中導入csv數據？","search_id":"202302092112460101501341671EC0193F","enter_answer_id":"6689076734060396811","outer_show_aid":"6689076734060396811","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":"/"}}}