sqlite3.OperationalError: table* already exists报错

报错原因

import sqlite3
con = sqlite3.connect(‘mydata.sqlite’)
query = “”“CREATE TABLE test (a VARCHAR(20), b VARCHAR(20), c REAL, d INTEGER)”""
con.execute(query)
con.commit()
数据库文件mydata.sqlite中已经存在test文件，再次新建test子文件会报错

解决方法

（1）重命名为test2
import sqlite3
con = sqlite3.connect(‘mydata.sqlite’)
query = “”“CREATE TABLE test2 (a VARCHAR(20), b VARCHAR(20), c REAL, d INTEGER)”""
con.execute(query)
con.commit()

(2)用异常机制
import sqlite3
con = sqlite3.connect(‘mydata.sqlite’)
try:
query = “”“CREATE TABLE test (a VARCHAR(20), b VARCHAR(20), c REAL, d INTEGER)”""
con.execute(query)
con.commit()
except:
print(query[13:]+’ already exists’)
finally:
data = [(‘Atlanta’, ‘Georgia’, 1.25, 6),
(‘Tallahassee’, ‘Florida’, 2.6, 3),
(‘Sacramento’, ‘California’, 1.7, 5),
(‘AlexanderWebber’,‘Wuhan’,1.8,7)]
con.executemany(“INSERT INTO test VALUES(?, ?, ?, ?)”, data)
con.commit()

注意try,except,finally下方的缩进
如果已存在test，则不再生成test文件

以上是原创的摸索出来的解决方案，觉得有帮助请点赞

链接:(https://blog.csdn.net/AlexanderWebber/article/details/107854153).