SQLite - Python
Python 标准库自带 sqlite3 模块：connect 建连、execute 执行、fetchall 取结果、with 自动提交。
Key PointsSQLite,Python,sqlite3,标准库,连接
讲解
Python 标准库自带 sqlite3 模块：connect 建连、execute 执行、fetchall 取结果、with 自动提交。
示例
Python
import sqlite3
conn = sqlite3.connect("test.db")
cur = conn.cursor()
cur.execute("CREATE TABLE IF NOT EXISTS company (id INTEGER PRIMARY KEY, name TEXT)")
cur.execute("INSERT INTO company (name) VALUES (?)", ("Google",))
conn.commit()
for row in cur.execute("SELECT * FROM company"):
print(row)
conn.close()Output
(1, 'Google')讲解
Python 标准库自带 sqlite3 模块：connect 建连、execute 执行、fetchall 取结果、with 自动提交。
示例
Python
import sqlite3
conn = sqlite3.connect("test.db")
cur = conn.cursor()
cur.execute("CREATE TABLE IF NOT EXISTS company (id INTEGER PRIMARY KEY, name TEXT)")
cur.execute("INSERT INTO company (name) VALUES (?)", ("Google",))
conn.commit()
for row in cur.execute("SELECT * FROM company"):
print(row)
conn.close()Output
(1, 'Google')