c 向mysql中存储图片

import mysql.connector
from mysql.connector import Error

def store_image(image_path, table_name, column_name):
    try:
        # 连接到MySQL数据库
        connection = mysql.connector.connect(
            host='localhost',
            database='your_database',
            user='your_username',
            password='your_password'
        )

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

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

            # 插入二进制数据到数据库
            query = f"INSERT INTO {table_name} ({column_name}) VALUES (%s)"
            cursor.execute(query, (binary_data,))
            connection.commit()

            print("图片存储成功！")

    except Error as e:
        print(f"Error: {e}")

    finally:
        if connection.is_connected():
            cursor.close()
            connection.close()
            print("MySQL连接已关闭")

# 使用示例
store_image('path_to_your_image.jpg', 'your_table', 'your_blob_column')