如何将(Jpeg)图像保存到MySql并在以后检索它？

import io

with open("image.jpg", "rb") as image_file:
    image_data = io.BytesIO(image_file.read())

import mysql.connector

cnx = mysql.connector.connect(user='username', password='password', host='localhost', database='database_name')

CREATE TABLE images (
    id INT AUTO_INCREMENT PRIMARY KEY,
    image_data BLOB
);

cursor = cnx.cursor()

query = "INSERT INTO images (image_data) VALUES (%s)"
data = (image_data.getvalue(),)
cursor.execute(query, data)

cnx.commit()
cursor.close()

cursor = cnx.cursor()

query = "SELECT image_data FROM images WHERE id = %s"
data = (image_id,)
cursor.execute(query, data)

result = cursor.fetchone()
image_data = result[0]

cursor.close()
cnx.close()

from PIL import Image

image = Image.open(io.BytesIO(image_data))
image.show()