Python Programs

Connect to database

import MySQLdb

db = MySQLdb.connect(host="localhost", port=3306, user="root", passwd="toot", db="qoz")

Query the database

cur = db.cursor()

cur.execute("SELECT name, phone_number \
    FROM coworkers \
    WHERE name='%s'" % (lastname)

Process returned query data

data = cur.fetchall()

for row in data:
    if row == None:
        exit
    print(row)

data = cur.fetchall()

while True:
    row = cur.fetchone()
    if row == None:
        break
    print(row)

Fetch one row

cur.fetchone()

This is handy when you’re doing queries like "SELECT COUNT(*) ..." which only returns a single row.

Insert data into database table

sql = "INSERT INTO company.employees (firstname) VALUES (%s)", ('Jane')
cur.execute(sql)
cur.commit()

Note: Any literal percent signs in the query string passed to execute() must be escaped, i.e. %%.

Close cursor and database connection

cur.close()
db.close()