mysql存储文件流

import mysql.connector
import os

# 连接数据库
db = mysql.connector.connect(
    host="localhost",
    user="yourusername",
    password="yourpassword",
    database="yourdatabase"
)

cursor = db.cursor()

# 读取文件
file_path = "path/to/your/file.jpg"
with open(file_path, 'rb') as file:
    file_data = file.read()

# 插入文件流到数据库
sql = "INSERT INTO files (name, data) VALUES (%s, %s)"
cursor.execute(sql, (os.path.basename(file_path), file_data))
db.commit()

cursor.close()
db.close()

import mysql.connector

# 连接数据库
db = mysql.connector.connect(
    host="localhost",
    user="yourusername",
    password="yourpassword",
    database="yourdatabase"
)

cursor = db.cursor()

# 查询文件流
file_id = 1
sql = "SELECT name, data FROM files WHERE id = %s"
cursor.execute(sql, (file_id,))
result = cursor.fetchone()

if result:
    file_name, file_data = result
    with open(f"downloaded_{file_name}", 'wb') as file:
        file.write(file_data)

cursor.close()
db.close()