将图像数据类型从一个表复制到另一个表

CREATE TABLE source_table (
    id INT AUTO_INCREMENT PRIMARY KEY,
    image_data MEDIUMBLOB NOT NULL
);

CREATE TABLE destination_table (
    id INT AUTO_INCREMENT PRIMARY KEY,
    image_data MEDIUMBLOB NOT NULL
);

import mysql.connector

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

# 从源表中读取图像数据
query = "SELECT image_data FROM source_table"
cursor.execute(query)

# 将图像数据插入到目标表中
for (image_data,) in cursor:
    insert_query = "INSERT INTO destination_table (image_data) VALUES (%s)"
    cursor.execute(insert_query, (image_data,))

# 提交更改并关闭连接
cnx.commit()
cursor.close()
cnx.close()