主页 / 问题 / 1534590
Accepted
RezDom
Asked:2023-08-07 05:26:35 +0800 CST2023-08-07 05:26:35 +0800 CST

SQL 查询错误 | sqlite3

  • 772

为什么我在这段代码中收到错误no such column: test2？看起来请求是正确的......

import sqlite3


db = sqlite3.connect('test.db')
cur = db.cursor()

cur.execute("CREATE TABLE IF NOT EXISTS abc(test1 TEXT, test2 TEXT, test3 TEXT)")
cur.execute("INSERT INTO abc VALUES (test2)",('aaaaaa'))

db.commit()
db.close()

完整错误：

File "d:\programm\BotParsSale\test.py", line 11, in <module>
    cur.execute("INSERT INTO abc VALUES (test2)",('aaaaaa'))
sqlite3.OperationalError: no such column: test2
python

1 个回答

  1. Best Answer
    import sqlite3

db = sqlite3.connect('test.db')
cur = db.cursor()

cur.execute("CREATE TABLE IF NOT EXISTS abc(test1 TEXT, test2 TEXT, test3 TEXT)")

cur.execute("INSERT INTO abc(test2) VALUES (?) ", ('aaaaaa',))
db.commit()

res = cur.execute("SELECT * FROM abc").fetchall()

print(res[0])
db.close()

(None, 'aaaaaa', None)
    • 2

相关问题