%d 格式化数字不是 str [英] %d format a number is required not str

问题描述

我有一个名为 tablename 的表，其中 idno 作为主 kry.如果用户在表中指定了 idno，我希望删除该行.这是我的代码:

I have a table named tablename with idno as primary kry. I want the row to be deleted if the user specifies the idno in the table. Here are my codes:

data3=raw_input("Enter the idno to del :",)
mydata=cursor.execute("DELETE FROM tablename where idno=%d", data3)
db.commit()

我收到此错误:

回溯(最近一次调用最后一次):文件C:\Python27\trertr.py"，第 50 行，在mydata=cursor.execute("DELETE FROM tablename where idno=%d", data3) File "C:\Python27\lib\site-packages\MySQLdb\cursors.py", line187，在执行query = query % tuple([db.literal(item) for item in args]) TypeError: %d format: a number is required, not str

Traceback (most recent call last): File "C:\Python27\trertr.py", line 50, in mydata=cursor.execute("DELETE FROM tablename where idno=%d", data3) File "C:\Python27\lib\site-packages\MySQLdb\cursors.py", line 187, in execute query = query % tuple([db.literal(item) for item in args]) TypeError: %d format: a number is required, not str

推荐答案

data3=int(raw_input("Enter the idno to del :",))

cursor.execute("DELETE FROM tablename where idno=%s", [data3])

经过多次尝试，我得到了对我有用的答案

After a lot of tries, I have got the answer which worked for me

这篇关于%d 格式化数字不是 str的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！