mysql connector python windows_mysql Windows Python目录中load connector语句错误

使用代码：import mysql.connectorcnx = mysql.connector.connect(user='usr', password='pswd',host='127.0.0.1',database='db')cursor = cnx.cursor()cursor.execute("LOAD DATA INFILE 'C:\\Users\\user\\Documents\\c

爱宝妈

169人浏览 · 2021-02-07 06:45:08

爱宝妈 · 2021-02-07 06:45:08 发布

使用代码：import mysql.connector

cnx = mysql.connector.connect(user='usr', password='pswd',

host='127.0.0.1',

database='db')

cursor = cnx.cursor()

cursor.execute(

"LOAD DATA INFILE 'C:\\Users\\user\\Documents\\csvFiles\\Lamborghini-data.csv' "

"INTO TABLE lamborghini "

"FIELDS TERMINATED BY ',' "

"ENCLOSED BY '\"' "

"LINES TERMINATED BY '\\n' "

"IGNORE 1 ROWS "

"(model_year, make, model, model_info, price, status, auction_location, auction_year);"

)

我成功地连接到数据库，但load语句出于某种原因查找“C:\xampp\mysql\data…”中的文件，而不是指定的路径。你知道吗

错误如下：Traceback (most recent call last):

File "createAndLoadDB.py", line 42, in

"LOAD DATA INFILE 'C:\\Users\\david\\Documents\\MecumProject2\\MecumScraper\\csvFiles\\Lamborghini-data.csv' "

File "C:\Users\david\Anaconda3\envs\MecumDBEnv\lib\site-packages\mysql\connector\cursor.py", line 566, in execute

self._handle_result(self._connection.cmd_query(stmt))

File "C:\Users\david\Anaconda3\envs\MecumDBEnv\lib\site-packages\mysql\connector\connection.py", line 549, in cmd_query

result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query))

File "C:\Users\david\Anaconda3\envs\MecumDBEnv\lib\site-packages\mysql\connector\connection.py", line 438, in _handle_result

raise errors.get_exception(packet)

mysql.connector.errors.DatabaseError: 29 (HY000): File 'C:\xampp\mysql\data\UsersdavidDocumentsMecumProject2MecumScrapercsvFilesLamborghini-data.csv' not found (Errcode: 2 "No such file or directory")

它似乎要从我指定的文件中删除“\\”，并在“C\xampp\mysql\data…”中搜索它。你知道吗

如果语句在.sql文件中，我可以成功地执行该语句，但是在python脚本中使用它时mysql.connector接口抛出上述错误。你知道吗