Python MySQL

This tutorial series shows you how to use MySQL Connector/Python to access MySQL databases from Python programs.

What you’ll learn:

  • Connect to MySQL server from a Python program
  • Insert, Select, Update, and Delete data in the database in Python.
  • Call MySQL stored procedures from Python
  • Writing / Reading BLOB data in MySQL database from Python.

Prerequisites

  • Python Programming
  • Basic MySQL
  • MySQL stored procedures
Python MySQL

Please note that all tutorials in this section are based on Python 3. If you’re looking to learn Python programming or refresh your Python knowledge quickly, you can check out the Python tutorial.

Section 1. Getting Started with MySQL Connector/Python

Section 2. Performing Basic Operations (CRUD)

This section shows you how to perform basic operations, including querying data, inserting data, updating data, and deleting data.

Section 3. Stored Procedures

This section shows how to effectively work with MySQL store procedures in Python

Section 4. Working with BLOB

This section covers working with BLOB data, enabling you to store large binary objects in the MySQL database. You’ll learn how to save BLOB data into the database, retrieve it, and save the data as a file.