å·¥å ·ï¼office excelãmysql
æ¥éª¤ï¼
1ãæå¼mysqlï¼ç¨mysqlå½ä»¤å建ä¸ä¸ªè¡¨ã
2ãæå¼office excelï¼æç §ç¨åºæä¾çå段填åç¸åºçæ°æ®ã
3ãæå¼mysql管çå·¥å ·ï¼æ©è¡¨æå¨çæ°æ®åºï¼ç¹å»æ°æ®åºååï¼å³é®æ°æ®ï¼éæ©import wizardï¼éæ©excel fileæ件ã
4ãç¹å»nextï¼éæ©å¯¹åºçexcelæ件ï¼éæ©ææåå 容çsheetï¼ç¹å»next ã
5ãfiled name row å°±æ¯å段æå¨excelä¸çä½ç½®ï¼ä¹å°±æ¯ç¬¬å è¡ãfirst data rowæ°æ®ä»åªä¸è¡å¼å§ãå¡«å®ç¹å»nextã
6ãéæ© target table ç®æ 对åºçæ°æ®åºï¼éæ©è¦å¯¼å ¥å°çæ°æ®åºè¡¨ä¸ã
7ãé»è®¤nextå°æåãå®æã