python - 我正在尝试通过 Python 中的输入语句通过行索引删除 SQLite3 表中的一行

Question

当我运行这段代码时：

delCard = input('Which card do you want to delete?: ')
c.execute ("DELETE from cards WHERE ROWID = int(delCard)");
conn.commit()

我收到此错误：

Traceback (most recent call last):
  File "H:\cc7.py", line 74, in <module>
    deleteAcard()
  File "H:\cc7.py", line 42, in deleteAcard
    c.execute ("DELETE FROM cards WHERE ROWID = idrow");
sqlite3.OperationalError: no such column: idrow

标签： pythonsqlite

Answer 1

尝试这个：

c.execute ("DELETE from cards WHERE ROWID = {}".format(int(delCard)));