主页
Python
Python sqlite3 模块
demo_ref_module_sqlite3_basic
运行 ❯
×
更改方向
保存代码
更改主题
import sqlite3 conn = sqlite3.connect(':memory:') cursor = conn.cursor() cursor.execute('CREATE TABLE users (name TEXT, age INTEGER)') cursor.execute("INSERT INTO users VALUES ('Tobias', 28)") conn.commit() cursor.execute('SELECT * FROM users') result = cursor.fetchone() print(f'User: {result[0]}, Age: {result[1]}')
User: Tobias, Age: 28