Python 101: Interactively learn how to program with Python 3/

...

Basic SQLite Queries

Let's learn SQL Queries in Python

We'll cover the following...

Wrapping Up

Press + to interact

import sqlite3
conn = sqlite3.connect("mydatabase.db")
#conn.row_factory = sqlite3.Row
cursor = conn.cursor()
sql = "SELECT * FROM albums WHERE artist=?"
cursor.execute(sql, [("Red")])
print(cursor.fetchall())  # or use fetchone()
print("\nHere's a listing of all the records in the table:\n")
for row in cursor.execute("SELECT rowid, * FROM albums ORDER BY artist"):
    print(row)
print("\nResults from a LIKE query:\n")
sql = """
SELECT * FROM albums 
WHERE title LIKE 'The%'"""
cursor.execute(sql)
print(cursor.fetchall())