ç±äºå·¥ä½éè¦ï¼ç»å¸¸éè¦å°mysqlæ°æ®åºä¸çæ°æ®å¯¼åºå°excelè¡¨æ ¼ï¼æè
éè¦å°excelè¡¨æ ¼æ°æ®å¯¼å
¥å°mysqlæ°æ®åºï¼æçæ¹æ³æ¯å
å°å®ä»¬é½è½¬æ¢æä¸ç§ä¸é´æ°æ®æ ¼å¼csvï¼execlæ°æ®å¯ä»¥ç´æ¥å¯¼åºä¸ºcsvæ ¼å¼ï¼csvæ ¼å¼ä¹å¯ä»¥ç´æ¥ç¨excelæå¼ï¼ãä¸é¢ä»ç»ä¸ä¸æä½æ¥éª¤ï¼csv导å
¥mysqlloaddatainfile'C:\\Users\\UserName\\Desktop\\test.csv'intotable`table`fieldsterminatedby','optionallyenclosedby'"'escapedby'"'linesterminatedby'\n';mysql导å
¥csvselect*from`table`loaddatainfile'C:\\Users\\UserName\\Desktop\\test.csv'fieldsterminatedby','optionallyenclosedby'"'escapedby'"'linesterminatedby'\n';å¦æä¹±ç ï¼å¯ç¨ç¸å
³ç¼è¾å¨æå¼.csvæ件ï¼å¦å为utf-8çcsv
温馨提示:答案为网友推荐,仅供参考