does PyMySQL support load data local infile?

320 views
Skip to first unread message

Darshan Talati

unread,
Jun 16, 2015, 11:19:09 AM6/16/15
to pymysq...@googlegroups.com
does PyMySQL support load data local infile?

David Darby

unread,
Nov 15, 2016, 5:20:25 PM11/15/16
to PyMySQL Users
Just to be clear since I spent hours search for this myself, PYMySQL does now support LOAD DATA LOCAL INFILE  but you must enable it in the database connection parameters. Ex. 
(host='localhost', user='username', password='password', database='databasename', charset='utf8mb4', cursorclass=pymysql.cursors.DictCursor, local_infile=True). The default is set to False.


Reply all
Reply to author
Forward
0 new messages