mysql数据库如何保存图片

import mysql.connector

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

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

# 插入图片数据到数据库
cursor = cnx.cursor()
insert_query = "INSERT INTO images (name, data) VALUES (%s, %s)"
data = ('image1', image_data)
cursor.execute(insert_query, data)

# 提交事务并关闭连接
cnx.commit()
cursor.close()
cnx.close()

import mysql.connector
import io
from PIL import Image

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

# 查询图片数据
cursor = cnx.cursor()
select_query = "SELECT data FROM images WHERE name = %s"
data = ('image1',)
cursor.execute(select_query, data)
result = cursor.fetchone()

# 将二进制数据转换为图片对象
image_data = result[0]
image = Image.open(io.BytesIO(image_data))

# 显示图片
image.show()

# 关闭连接
cursor.close()
cnx.close()