使用pymysql执行INSERT语句，没有报错但数据未插入数据库，是什么原因？

def save_db(cons):
    db = pymysql.connect(host='127.0.0.1', user='root', password='root', port=3306)
    cursor = db.cursor()
    sql = 'insert into quote(jy_time,open_price,high_price,low_price,over_price,zhangdiee,zhangdief,chengjiaol,chengjiaoj,zhenfu,huanshoul) value (%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)'
    print('插入中...')
    try:
        cursor.execute(sql, (cons))
        print(cons)
        db.commit()
    except:
        print('失败了啊')
        db.rollback()
    db.close()

def save_db(cons):
    db = pymysql.connect(host='127.0.0.1', user='root', password='root', port=3306)
    cursor = db.cursor()
    sql = 'INSERT INTO quote(jy_time,open_price,high_price,low_price,over_price,zhangdiee,zhangdief,chengjiaol,chengjiaoj,zhenfu,huanshoul) VALUE (%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)'
    print('插入中...')
    try:
        cursor.execute(sql, (cons))
        print(cons)
        db.commit()
    except pymysql.err.ProgrammingError as e:
        print('失败了啊')
        print(e)
        db.rollback()
    db.close()