Error:
When using pymysql, an error occurs when using% d to pass parameters in the SQL statement. As shown in the figure: 
Error information: typeerror:% d format: a number is required, not str
Cause of problem:
When a parameter of type int is passed in, it is converted to a parameter of type str. Therefore, the solution is to change% d into% s, pass in int type, and it can still be executed.
Modified: 
Data of type int passed in:
Can execute successfully
Solution:
When data of type int is passed in, the parameter is still passed with% s.
Read More:
- Error in v-on handler (Promise/async): “Error: Request failed with status code 500“
- Error: required request body is missing, @ requestbody annotation usage
- TypeError: int() can’t convert non-string with explicit base
- How to Solve Infinite scroll the pit encountered
- TypeError: Required argument ‘mat‘ (pos 2) not found
- Domain error in object XXX “other” domain “other” rejected values and atm913
- django.core.exceptions . improverconfigured: mysqlclient 1.4.0 or new is required; you have
- Remember the error of using unaddressable value of a novice goer
- Unsupported operation types unsupported operation data types
- Use of C + + ifstream and error handling
- JPA setting in parameter error
- 12-web security — error injection based on SQL Server — and, convert, cast
- Spring data JAP SQL error:17059 SQL State:99999
- Mybatis passes in multiple parameters to mapper. And uses @param details to report an error
- An error keyerror255 was reported when pymysql connect to MySQL
- Python uses CX_ Oracle batch insert error report ora-01036 error solution
- Python error: pandas.errors.ParserError: Error tokenizing data. C error: Expected 3……
- Python about typeerror: required argument ‘mat’ (POS 2) not found error resolution
- Solve the problem of error loading MySQL DB module. Encountered during Django project
- Python json.dumps () json.dump The difference between ()