pymysql为什么更新数据库总提示1054

Question

    sql = "UPDATE arms SET gem2='%s' WHERE id = ('%d')" % ('红玛瑙',new_id)
    (1054, "Unknown column 'gem2' in 'field list'")
    
    
    sql = "UPDATE arms SET gem2='红玛瑙' WHERE id = ('%d')" % new_id
    (1054, "Unknown column 'gem2' in 'field list'")
    这样也会报错这是为什么gem1就不会报错.字符串也加入引号了

Answer 1

用下面的这个sql试试？

sql = "UPDATE arms SET gem2='%s' WHERE id = ('%d')" % (pymysql.escape_string('红玛瑙'),int(new_id))

Answer 2

sql应该是没啥问题，尤其是gem1不会报错的情况下。检查一下gem2前后是不是有空格或者换行符。