source 命令无法使用？

Question

无法导入？？？

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'source D:\Server\three\public\export.sql' at line 1

function ImportDB($dbh) {
  $sql = 'source '.realpath('export.sql');
  try {
    $stmt = $dbh->prepare($sql);
    var_dump($stmt->execute());
    var_dump($stmt->errorInfo());
  }
  catch (PDOException $e) {
    print $e->getMessage();
  }
}

注：导入包没问题：

Answer 1

execute()只能执行SQL语句，而SOURCE虽然也能在mysqlclient中执行，但是并不是sql语句，所以d会执行失败，建议直接用php的exec命令进行执行

Answer 2

导入前的先use一下哪个库吧,我用cmd都需要把路径的斜线换成反斜线要不会报错,希望对你有帮助

Answer 3

SQL关键字冲突 ?