a or b in str - Shuang0420/Shuang0420.github.io GitHub Wiki

# row[6]中有'正确''错误''推荐'三种属性
def insertIntoLingyun(row_list):
    for row in row_list:
        if ('错误' or '推荐' in row[6]):
            row[3] = row[8]
        try:
            cur.execute("INSERT IGNORE INTO `Lingyun` VALUES ('" + row[1] + "','"+ row[3] + "','"+ row[4] + "','"+ row[6] + "','" + row[8] + "')")
        except:
           # Rollback in case there is any error
           conn.rollback()
    conn.commit()

如图，看到'正确'一行本该有的标准答案不见了

待补充

def insertIntoLingyun(row_list):
    for row in row_list:
        if ('错误' in row[6] or '推荐' in row[6]):
            row[3] = row[8]
        try:
            cur.execute("INSERT IGNORE INTO `Lingyun` VALUES ('" + row[1] + "','"+ row[3] + "','"+ row[4] + "','"+ row[6] + "','" + row[8] + "')")
        except:
           # Rollback in case there is any error
           conn.rollback()
    conn.commit()