Why does pymysql update the database with a total prompt of 1054?

    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.

Pymysql python mysql

Apr.05,2021

try using the following sql?

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

sql should be fine, especially if gem1 will not report an error. Check to see if there are spaces or newline characters before and after gem2.

Previous: How to use boostrap's js,typescript in angular5 to compile an error, and how to solve it?

Next: What kind of typescript syntax is this?

How to solve the problem that the string numbers are saved in the database and all of them are killed from the front to the zero?
some data are like this: 1186486, 0215648, 00064876, mysql stores data to columns of char type, data is stored in front of 0, all columns are killed. How to solve the short ones are preceded by 0, and the data is a string in python and does not ki...

Pymysql python mysql

Mar.07,2021