Basic SQLite Queries

Explore how to create and interact with SQLite databases in Python by writing queries to select, order, and search records. Understand the use of cursor objects, fetch methods, and SQL commands like SELECT and LIKE to manage and retrieve data efficiently.

We'll cover the following...

Wrapping Up

Python 3.5

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())