萌新求解！

快秃头的猫

import  sqlite3
conn=sqlite3.connect('text2.db')
cursor=conn.cursor()
#cursor.execute("delete form exam")
cursor.execute('create table[exam]([question]varchar(80)null,[Ansawer_A] varchar(1)null,[Answer_B] varchar(1)null,[Answer_C] varchar(1)null,[Answer_D] varchar(1)null,[right_Answer] varchar(1) null)')
cursor.execute("insert into exam(question,Answer_A,Answer_B,Answer_C,Answer_D,right_Answer)values('哈雷彗星的平均周期为', '54','56','58'，'C')")
cursor.execute("insert into exam (question,Answer_A,Answer_B,Answer_C,Answer_D,right_Answer)values('蜀国位于哪’，‘贵州’，‘四川’，'上海','倒萨的','A'")
cursor.execute("insert into exam (question,Answer_A,Answer_B,Answer_C,Answer_D,right_Answer)values('蜀国的大帅是谁’，‘刘备’，‘早操’，'速速','玩的'，'B'")
cursor.execute("insert into exam (question,Answer_A,Answer_B,Answer_C,Answer_D,right_Answer)values('蜀国位于哪’，‘贵州’，‘四川’,'广西'，'汕头'，'B'")
print(cursor.rowcount)
cursor.close()
conn.commit()
conn.close()
conn=sqlite3.connect('test2.db')
cursor=conn.cursor()
#执行查询语句
cursor.execute('select * from exam')
values=cursor.fetchall()
cursor.close()
conn.close()
import  tkinter
from tkinter import *
from tkinter.messagebox import  *
def callnext():
    global k
    global score
    useranswer=r.get()
    print(r.get())
    if useranswer==values[k][5]:
        showinfo("恭喜")
        score+=10
    else:
        showinfo("遗憾")
    k=k+1
    if k>=len(values):
        showinfo('完了')
        return
    timu['text']=values[k][0]
    radio1['text']=values[k][1]
    radio2['text'] = values[k][2]
    radio3['text']=values[k][3]
    radio4['text']=values[k][4]
    r.set('E')
def callResult():
    showinfo("你的得分",str(score))
运行结果为
C:\Users\中二病永不毕业\AppData\Local\Programs\Python\Python37\python.exe D:/py/数据库.py
Traceback (most recent call last):
  File "D:/py/数据库.py", line 5, in <module>
    cursor.execute('create table[exam]([question]varchar(80)null,[Ansawer_A] varchar(1)null,[Answer_B] varchar(1)null,[Answer_C] varchar(1)null,[Answer_D] varchar(1)null,[right_Answer] varchar(1) null)')
sqlite3.OperationalError: table [exam] already exists

Process finished with exit code 1



求讲解

wp231957

sqlite3.OperationalError: table [exam] already exists

看提示信息  表名exam 已经存在

枫树霜雪

cursor.execute('create table[exam]([question]varchar(80)null,[Ansawer_A] varchar(1)null,[Answer_B] varchar(1)null,[Answer_C] varchar(1)null,[Answer_D] varchar(1)null,[right_Answer] varchar(1) null)')这句话前面加一个判断，如果表不存在执行这句，如果已存在就跳过