chatgpt / test.py
Liuli's picture
test
ef7b87e
raw
history blame contribute delete
234 Bytes
import sqlite3
mydb=sqlite3.connect("user.db")
## 读取sqlite3的数据
cursor=mydb.cursor()
#查询表名
cursor.execute("SELECT username,password FROM user WHERE expire_time > date('now');")
Tables=cursor.fetchall()
print(Tables)