如何在 Jupyter Notebook 执行和学习 SQL 语句（中）

1. 基础SQL操作

创建数据库和表，插入数据：

import sqlite3# 创建SQLite数据库并连接
conn = sqlite3.connect('example.db')
cursor = conn.cursor()# 创建用户表
cursor.execute('''CREATE TABLE IF NOT EXISTS users (id INTEGER PRIMARY KEY AUTOINCREMENT,name TEXT NOT NULL,age INTEGER NOT NULL,email TEXT)
''')# 插入数据
cursor.execute("INSERT INTO users (name, age, email) VALUES ('Alice', 25, 'alice@example.com')")
cursor.execute("INSERT INTO users (name, age, email) VALUES ('Bob', 30, 'bob@example.com')")
cursor.execute("INSERT INTO users (name, age, email) VALUES ('Charlie', 35, 'charlie@example.com')")
cursor.execute("INSERT INTO users (name, age, email) VALUES ('David', 40, 'david@example.com')")conn.commit()
conn.close()

查询数据：

conn = sqlite3.connect('example.db')
cursor = conn.cursor()# 查询所有用户
cursor.execute("SELECT * FROM users")
rows = cursor.fetchall()for row in rows:print(row)conn.close()