1. 从access中导出数据为文本格式。
2. 编码转换,可用vs.net
3. Load Data InFile 'E:/temp/GeoConcepts_plus1.txt' Into Table `geoconcepts`Fields Terminated By ',' Enclosed By '$' Escaped By '$' Lines Terminated By '\r\n';
1. 从access中导出数据为文本格式。
2. 编码转换,可用vs.net
3. Load Data InFile 'E:/temp/GeoConcepts_plus1.txt' Into Table `geoconcepts`Fields Terminated By ',' Enclosed By '$' Escaped By '$' Lines Terminated By '\r\n';
转载于:https://www.cnblogs.com/bluemaplestudio/archive/2012/05/14/2498767.html