在MySQL数据库表列中插入带有PyQt5的图像文件

CREATE TABLE images (
    id INT AUTO_INCREMENT PRIMARY KEY,
    image BLOB
);

from PyQt5.QtGui import QImage
from PyQt5.QtCore import QByteArray

# 加载图像文件
image = QImage("image.jpg")

# 将图像文件转换为字节流
byte_array = QByteArray()
buffer = QBuffer(byte_array)
buffer.open(QIODevice.WriteOnly)
image.save(buffer, "JPG")

import mysql.connector

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

# 创建游标对象
cursor = cnx.cursor()

# 将图像文件插入到数据库表中
insert_query = "INSERT INTO images (image) VALUES (%s)"
image_data = (byte_array,)
cursor.execute(insert_query, image_data)

# 提交更改
cnx.commit()

# 关闭游标和数据库连接
cursor.close()
cnx.close()