mysql 能存储图像吗

import mysql.connector
import os

mydb = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  password="yourpassword",
  database="mydatabase"
)

mycursor = mydb.cursor()

def store_image(image_path, image_name):
    with open(image_path, "rb") as image_file:
        image_data = image_file.read()
    sql = "INSERT INTO images (image_name, image_data) VALUES (%s, %s)"
    val = (image_name, image_data)
    mycursor.execute(sql, val)
    mydb.commit()

def retrieve_image(image_name, output_path):
    sql = "SELECT image_data FROM images WHERE image_name = %s"
    val = (image_name,)
    mycursor.execute(sql, val)
    result = mycursor.fetchone()
    if result:
        with open(os.path.join(output_path, image_name), "wb") as image_file:
            image_file.write(result[0])
    else:
        print(f"Image '{image_name}' not found.")


#Example usage
store_image("path/to/your/image.jpg", "myimage.jpg")
retrieve_image("myimage.jpg", "path/to/output/directory")

mycursor.close()
mydb.close()