source 命令无法使用?
程序员文章站
2022-05-12 08:27:58
...
无法导入???
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();
}
}
注:导入包没问题:
回复内容:
无法导入???
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();
}
}
注:导入包没问题:
execute()
只能执行SQL语句,而SOURCE
虽然也能在mysqlclient
中执行,但是并不是sql语句,所以d会执行失败,建议直接用php的exec
命令进行执行
导入前的先use一下哪个库吧,我用cmd都需要把路径的斜线换成反斜线要不会报错,希望对你有帮助