基本操作

import sqlite3

conn = sqlite3.connect('example.db')
cursor = conn.cursor()

cursor.execute('CREATE TABLE users (id INTEGER PRIMARY KEY, name TEXT)')
cursor.execute('INSERT INTO users (name) VALUES (?)', ('Alice',))
conn.commit()

查询数据

cursor.execute('SELECT * FROM users')
rows = cursor.fetchall()
for row in rows:
   print(row)

转载请注明：周志洋的博客 » Python实用技巧-SQLite 数据库