c mysql读取二进制

-- 创建表
CREATE TABLE images (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255),
    image_data LONGBLOB
);

-- 插入数据
INSERT INTO images (name, image_data) VALUES ('example.jpg', LOAD_FILE('/path/to/example.jpg'));

-- 读取数据
SELECT name, image_data FROM images WHERE id = 1;

import mysql.connector

# 连接数据库
conn = mysql.connector.connect(user='user', password='password', host='host', database='database')
cursor = conn.cursor()

# 查询数据
cursor.execute("SELECT image_data FROM images WHERE id = 1")
result = cursor.fetchone()

# 处理二进制数据
image_data = result[0]
with open('downloaded_image.jpg', 'wb') as f:
    f.write(image_data)

cursor.close()
conn.close()