使用mysql打开数据库中的图像

CREATE TABLE images (
    id INT PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(255) NOT NULL,
    image BLOB NOT NULL
);

import mysql.connector

# 连接到MySQL数据库
conn = mysql.connector.connect(
    host="localhost",
    user="username",
    password="password",
    database="database_name"
)

# 读取图像文件
with open("image.jpg", "rb") as file:
    image_data = file.read()

# 执行INSERT语句插入图像数据
cursor = conn.cursor()
sql = "INSERT INTO images (name, image) VALUES (%s, %s)"
params = ("image.jpg", image_data)
cursor.execute(sql, params)
conn.commit()

# 关闭数据库连接
cursor.close()
conn.close()

import mysql.connector

# 连接到MySQL数据库
conn = mysql.connector.connect(
    host="localhost",
    user="username",
    password="password",
    database="database_name"
)

# 执行SELECT语句检索图像数据
cursor = conn.cursor()
sql = "SELECT image FROM images WHERE name = %s"
params = ("image.jpg",)
cursor.execute(sql, params)

# 读取并保存图像数据到文件
with open("retrieved_image.jpg", "wb") as file:
    image_data = cursor.fetchone()[0]
    file.write(image_data)

# 关闭数据库连接
cursor.close()
conn.close()