add a file into a mysql BLOB column

upload.py

""" Example for adding a file into a blob

    CREATE TABLE test (
         id INT AUTO_INCREMENT,
         data LONGBLOB NOT NULL,
         PRIMARY KEY (id)
    );

pip install --upgrade --user mysqlclient
"""
import MySQLdb

db = MySQLdb.connect(
    host="127.0.0.1",
    port=3306,
    user="root",
    passwd="test",
    db="test")

cursor = db.cursor()
data = open('data.test', 'rb').read()
sql = "INSERT INTO test(data) VALUES (_binary %s)"
print(cursor.execute(sql, (data,)))
db.commit()