向mysql存入图片

import mysql.connector
from mysql.connector import Error

def store_image_to_mysql(image_path):
    try:
        # 连接到MySQL数据库
        connection = mysql.connector.connect(host='localhost',
                                             database='test_db',
                                             user='root',
                                             password='password')

        if connection.is_connected():
            cursor = connection.cursor()

            # 读取图片文件为二进制数据
            with open(image_path, 'rb') as file:
                binary_data = file.read()

            # 插入图片数据到数据库
            insert_query = "INSERT INTO images (name, data) VALUES (%s, %s)"
            cursor.execute(insert_query, ('example_image', binary_data))
            connection.commit()

            print("图片已成功存储到MySQL数据库中")

    except Error as e:
        print("连接或存储过程中发生错误：", e)

    finally:
        if connection.is_connected():
            cursor.close()
            connection.close()

# 调用函数存储图片
store_image_to_mysql('path_to_your_image.jpg')