没有错误，但在.sql文件中加载infile在python脚本中不起作用

Question

我有一个.sql文件，它有多个加载命令，如下所示，

LOAD DATA LOCAL INFILE 'csvname.csv' INTO TABLE table_name FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY 'n' IGNORE 1 LINES(....);
LOAD DATA LOCAL INFILE 'csvname.csv' INTO TABLE table_name FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY 'n' IGNORE 1 LINES(....);

它在SQL终端中运行得很好，但在脚本中我没有得到任何错误仍然没有加载

我的代码：

#db = pymysql.connect(**db_opts)
conn = pymysql.connect(rds_host, user=name, passwd=password, db=db_name, connect_timeout=5,local_infile=True)
cur = conn.cursor()
print ("Connected!n")
for line in open('load.sql','r'):
print(line)
cur.execute(line)
conn.close()

有人能帮忙吗？

Answer 1

Pymysql不支持load命令。