[PYTHON] LOAD DATA with PyMysql

def load_data(file_path):
    with conn.cursor() as cursor:
        sql = """
LOAD DATA LOCAL INFILE '{}' 
INTO TABLE Sample 
CHARACTER SET utf8 
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' 
LINES TERMINATED BY '\n' 
IGNORE 1 LINES 
        """.format(file_path)
        cursor.execute(sql)

pymysql.err.InternalError: (1148, 'The used command is not allowed with this MySQL version')

pymysql.connect(
    :
    local_infile=True
)

Recommended Posts