如何使用sql查询从表中检索图像并将其保存到不同服务器的文件夹中

SELECT image_data, image_name, server_name
FROM images
WHERE condition;

import os
import mysql.connector

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

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

# 执行SQL查询
query = "SELECT image_data, image_name, server_name FROM images WHERE condition"
cursor.execute(query)

# 遍历查询结果
for (image_data, image_name, server_name) in cursor:
    # 保存图像到文件夹
    folder_path = "/path/to/server/folder/" + server_name
    if not os.path.exists(folder_path):
        os.makedirs(folder_path)
    file_path = os.path.join(folder_path, image_name)
    with open(file_path, 'wb') as file:
        file.write(image_data)

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