MySQL with Python

MySQL with Python — a practical guide to Python MySQL with clear examples you can reuse in real projects.

Python Tutorial Series (62/95). Prefer one article? Read the complete Python tutorial.

Short description

Install a MySQL driver, connect with credentials from environment variables, and use parameterized SQL.

PyMySQL sketch

# pip install PyMySQL
import pymysql

conn = pymysql.connect(host='127.0.0.1', user='root', password='', database='demo')
with conn.cursor() as cur:
    cur.execute('SELECT NOW()')
    print(cur.fetchone())
conn.close()