python mysql保存图片

pip install mysql-connector-python

import mysql.connector
from mysql.connector import Error
import os

def save_image_to_mysql(image_path, table_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} (image_name, image_data) VALUES (%s, %s)"
            cursor.execute(query, (os.path.basename(image_path), binary_data))
            connection.commit()

            print("图片已成功保存到数据库")

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

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

# 使用示例
save_image_to_mysql('path_to_your_image.jpg', 'images')

CREATE TABLE images (
    id INT AUTO_INCREMENT PRIMARY KEY,
    image_name VARCHAR(255) NOT NULL,
    image_data LONGBLOB NOT NULL
);