Python：将SQLite数据库中的图片导出来并且保存png格式

# -*- coding: utf-8 -*-
# @Time : 2022/9/3
# @Author : leict
# @File : SQLiteExportPicture.py


# -------------
# 保存图片
# -------------
import sqlite3
import pandas as pd


def saveImage(_id, byte):
    f = open('%s_image.png' % _id, 'wb')
    f.write(byte)
    f.close()
    return


if __name__ == '__main__':
    conn = sqlite3.connect("G:\PictureImportSQLite\src\应用题四年级（上）.dt")
    cur = conn.cursor()
    cur.execute("select * from  picture")

    # 获取table所有字段名
    col_name_list = [tuple[0] for tuple in cur.description]

    # 所有记录列表
    record_all = cur.fetchall()
    df = pd.DataFrame(record_all, columns=col_name_list)

    for index in range(len(df)):
        bytes_id = df['_id'][index]
        bytes_img = df['image'][index]
        saveImage(bytes_id, bytes_img)

    print("----------------执行完成-----总个数：%s" % len(df))

显示结果：