Python Database Access

Understand the idea

In this lesson, explore python database access. Study the SQL example, run it in the lab when applicable, and consider how it relates to real database systems.

import sqlite3
con = sqlite3.connect("app.db")
rows = con.execute("SELECT * FROM users WHERE id=?", (1,)).fetchall()