执行代码:
$filename = __ROOTPATH__.'/tmp/zcode-1-1-1.sql';
$sql = "LOAD DATA LOCAL INFILE '$filename' INTO TABLE `mytab` FIELDS TERMINATED BY ',' LINES TERMINATED BY '|'";
异常原因:
$filename 必须为相对路径,windows下的绝对路径抛出如下异常:
Can't find file 'D:iisphp/tmp/zcode-1-1-1.sql'
解决方案:
将绝对路径改成相对路径即可,如下:
$filename = './../../tmp/zcode-1-1-1.sql';