My insert into got error, meanwhile I don't know which part of MySQL that got wrong
listCol = []
colNames = ["kpi","performance","learning","competency","learning","kerjaIbadah","apresiasi","lebihCepat","aktifBersama"]
for row in associationRules:
left = row[0]
right = row[1]
support = row[5]
confidence = row[2]
lift = row[3]
conviction = row[4]
cur = mysql.connection.cursor()
cur.execute("INSERT INTO asosiasi (leftHand,rightHand,support,confidence,lift,conviction,minSupp,minConf,cluster,tahun) VALUES (%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)",(left,right,support,confidence,lift,conviction,minSupp,minConf,cluster,tahun))
mysql.connection.commit()```