mysql数据库图片导出到excel

SELECT image_column FROM table_name;

import mysql.connector
import io

# 连接到MySQL数据库
conn = mysql.connector.connect(host='your_host', user='your_username', password='your_password', database='your_database')

# 创建一个游标对象
cursor = conn.cursor()

# 查询图片数据
cursor.execute("SELECT image_column FROM table_name")
result = cursor.fetchone()

# 将图片数据写入临时文件
with open('image.jpg', 'wb') as file:
    file.write(result[0])

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

from openpyxl import Workbook
from openpyxl.drawing.image import Image

# 创建一个新的Excel工作簿
workbook = Workbook()
sheet = workbook.active

# 在Excel工作表中插入图片
img = Image('image.jpg')
sheet.add_image(img, 'A1')

# 保存Excel文件
workbook.save('output.xlsx')