SlieFamily / ErikaBot

A QQ(Tencent) robot created by go-cqhttp & nonebot2
12 stars 3 forks source link

删除语录库中奇怪的`汐宝语录` #17

Closed SlieFamily closed 2 years ago

SlieFamily commented 2 years ago

不知道是谁加的特殊字符,我以为是回车,其实不是……

SlieFamily commented 2 years ago

解决方案:


mport sqlite3
db = sqlite3.connect('anas.db')
cur = db.cursor()
cur.execute('select name from sqlite_master where type="table" and name like "%汐%"')
name = cur.fetchall()[0][0]
print(name)
cur.execute(f'DROP table "{name}"')
db.commit()