php - 您的 SQL 语法有误

Question

想知道是否有人能找到其中的错误:

    $sqlinsert = "LOAD DATA LOCAL INFILE 
\'$target_path\' INTO TABLE 'db_usergroup' 
FIELDS TERMINATED BY \',\' ENCLOSED BY \'\"\' ESCAPED BY \'\\\\\' 
LINES TERMINATED BY \'\\r\\n\'";

$target_path 的确切名称略有不同，但示例如下:

temp/24_09_12_16_57_27_invoice_example.csv

我收到这个错误:

    An error occurred. The file could not be imported. 
Error with MySQL Query: You have an error in your SQL syntax; 
check the manual that corresponds to your MySQL server version 
for the right syntax to use near 
'\'temp/24_09_12_16_57_27_invoice_example.csv' INTO TABLE 
'db_usergroup' FIELDS T' at line 1

非常感谢所有帮助。

Answer 1

为什么要转义目标路径中的引号？我认为没有必要。

您通常可以通过检查 附近的正确语法 后的前几个字符来准确判断错误是什么，这似乎确实表明反斜杠有问题。

尝试:

$sqlinsert = "LOAD DATA LOCAL INFILE '$target_path' INTO TABLE ...