mysql 读取二进制文件

SELECT blob_column FROM table_name WHERE condition;

import mysql.connector

db = mysql.connector.connect(host="localhost", user="user", password="password", database="database")
cursor = db.cursor()

cursor.execute("SELECT blob_column FROM table_name WHERE condition")
result = cursor.fetchone()

with open("output.bin", "wb") as file:
    file.write(result[0])

import mysql.connector

db = mysql.connector.connect(host="localhost", user="user", password="password", database="database")
cursor = db.cursor()

cursor.execute("SELECT blob_column FROM table_name WHERE condition LIMIT %s OFFSET %s", (chunk_size, offset))
result = cursor.fetchone()

with open("output.bin", "wb") as file:
    while result:
        file.write(result[0])
        offset += chunk_size
        cursor.execute("SELECT blob_column FROM table_name WHERE condition LIMIT %s OFFSET %s", (chunk_size, offset))
        result = cursor.fetchone()

import mysql.connector

db = mysql.connector.connect(host="localhost", user="user", password="password", database="database")
cursor = db.cursor()

cursor.execute("SELECT blob_column FROM table_name WHERE condition")
result = cursor.fetchone()

with open("output.bin", "wb") as file:
    while True:
        chunk = result[0][:chunk_size]
        if not chunk:
            break
        file.write(chunk)
        result[0] = result[0][chunk_size:]