mysql数据库提交图片代码

import mysql.connector
from mysql.connector import Error

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

        # 创建游标
        cursor = connection.cursor()

        # 读取图片数据
        with open(image_path, 'rb') as file:
            image_data = file.read()

        # 执行插入图片数据的SQL语句
        sql_query = "INSERT INTO images (image_data) VALUES (%s)"
        cursor.execute(sql_query, (image_data,))

        # 提交事务
        connection.commit()
        print("图片已成功提交到MySQL数据库")

    except Error as e:
        print("Error:", e)

    finally:
        # 关闭数据库连接
        if connection.is_connected():
            cursor.close()
            connection.close()
            print("数据库连接已关闭")

# 调用函数提交图片数据
insert_image('/path/to/image.jpg')