<分区> 分区>
更新 1: 另一条线有效(感谢您的帮助!)。现在我尝试运行以下命令,但这也不起作用,第 13 行出现错误:sqlite3.OperationalError: near ",": syntax error
代码如下:
cur.execute("CREATE TABLE Progress(Id INTEGER PRIMARY, Username STRING, Topic1 STRING, Topic2 STRING, Topic3 STRING, Topic4 STRING, 1Result STRING, 2Result STRING, 3Result STRING, 4Result STRING, TResut STRING, TCorrect INTEGER, TWrong INTEGER, TAttempted INTEGER)")
cur.exectue("INSERT INTO Progress VALUES(1, 'Admin', 'Algebra', 'Number', 'Shape, Space and Measures', 'Handling Data', '100%', '100%', '100%', '100%', '100%', '10', '0', '10')")
我创建了一个如下所示的 SQL 表,并试图将一些数据输入到表中,但我不断收到以下错误:sqlite3.OperationalError: near "1": syntax error
con = lite.connect('Records.db')
with con:
cur = con.cursor()
cur.execute("CREATE TABLE Questions(Id INTEGER PRIMARY KEY, Question STRING, Answer STRING, Mark INTEGER, Topic STRING, Incorrect STRING, QType STRING)")
cur.execute("INSERT INTO Questions(1, 'What is 2/3 of 6?', '4', '1', 'Fractions', 'None', 'Numerical')")
