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, &quo...
python3.6+pymysql+mysql8.0 you can log in normally with your root account in terminal, as shown in the following figure pymysql it s not okay to create a new user, but you can log in normally in terminal. preliminary judgment is still a proble...
insert but the data is a number, which is stored in the database as a string, and the corresponding field in the database is also of string type The python statement goes like this: sql = insert into uhaoma343 (riqi,uhaoma) values({},{}) .format(r...
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...