import CSV not support Chinese folder and file name
“import CSV” function not support Chinese folder and file name
LOAD DATA LOW_PRIORITY LOCAL INFILE 'D:\\用户数据\\Administrator\\桌面\\测试.csv' REPLACE INTO TABLE `testdb`.`info` CHARACTER SET gbk FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '"' LINES TERMINATED BY '\r\n' IGNORE 1 LINES (`billcertino`, `identitytype`, `saledate`, `saletime`, `trantype`, `stateflag`);
/* SQL Error (2): File 'D:\用户数据\Administrator\桌面\测试.csv' not found (Errcode: 2) */
/* SQL Error (2): File 'D:\用户数据\Administrator\桌面\测试.csv' not found (Errcode: 2) */
Please login to leave a reply, or register at first.