PHP的PDO执行MYSQL的LOAD DATA INFILE样例代码

$dsn = 'mysql:dbname=name;host=ip;port=3306';$user = 'user';$pwd = 'password';// 这里PDO::MYSQL_ATTR_LOCAL_INFILE => true需要设置；$options = [PDO::MYSQL_ATTR_LOCAL_INFILE => true];$db = new PDO($dsn, $user, $pwd, $options);try {    $load = <<<loadLOAD DATA LOCAL INFILE './sqlload.data' INTO TABLE tablename FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' (  str1,str2,str3,str4,str5,str6,str7,str8,str9,str10);load;    $db->exec($load);} catch (Exception $e) {    var_dump($e->getMessage());}

LOAD DATA INFILE语法：https://dev.mysql.com/doc/refman/5.7/en/load-data.html