ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '%s IGNORE INTO TABLE jeremy_table_test FIELDS TERMINATED BY ',' LINES TERMINATED' at line 1

date_sourced, sha1, suggested, vsdt, trendx, falcon, notes, mtf

SHA1,suggestedName

import mysql.connector
mydb = mysql.connector.connect(user='root', password='',
host='localhost',database='jeremy_db')

cursor = mydb.cursor()
query = "LOAD DATA INFILE %s IGNORE INTO TABLE jeremy_table_test FIELDS TERMINATED BY ',' LINES TERMINATED BY 'rn' IGNORE 1 LINES (@col1,@col2) set suggested=@col2 where sha1=@col1"
cursor.execute(query, (fullPath))
mydb.commit()