Operand should contain 1 column(s) when insert on mysql flask

Viewed 8

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()```
0 Answers
Related