Python/MySQL-加载数据本地文件 [英] Python/MySQL - LOAD DATA LOCAL INFILE
问题描述
我正在将mysql连接器用于Python,并且试图通过Python(Windows)运行以下SQL语句-这是一个.csv文件:
I am using the mysql connector for Python and I'm trying to run the following SQL statement via Python (Windows) - It's a .csv file:
sql1 = ('SET GLOBAL local_infile = "ON";')
cursor.execute(sql1)
sql2 = ('LOAD DATA LOCAL INFILE "' + path[1:-1] + '" INTO TABLE mytable COLUMNS TERMINATED BY "," LINES TERMINATED BY "\\r\\n" (COL0, COL1, COL2, COL3, COL4, COL5, COL6) SET COL7 = "'some_data'";')
cursor.execute(sql2)
但是当我尝试执行时,我收到以下异常:
but when I try to execute I receive the following exception:
1148(42000):此MySQL版本不允许使用所使用的命令
1148 (42000): The used command is not allowed with this MySQL version
如果我尝试在mysql控制台上执行LOAD DATA LOCAL INFILE,则一切运行正常.
If I try to execute LOAD DATA LOCAL INFILE on mysql console, everything runs fine.
推荐答案
默认情况下,使用连接器/Python禁用加载数据文件 在创建连接集LOCAL_FILES客户端标志时,如下所示:
Load Data Infile is disabled by default with Connector/Python while creating the connection set LOCAL_FILES client flag like this:
from mysql.connector.constants import ClientFlag
conn = mysql.connector.connect(...., client_flags=[ClientFlag.LOCAL_FILES])
这篇关于Python/MySQL-加载数据本地文件的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!