mysql存储word文档

CREATE TABLE documents (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255) NOT NULL,
    content LONGBLOB NOT NULL
);

import mysql.connector
from mysql.connector import Error

def insert_document(name, file_path):
    try:
        connection = mysql.connector.connect(host='localhost',
                                             database='your_database',
                                             user='your_user',
                                             password='your_password')

        cursor = connection.cursor()

        with open(file_path, 'rb') as file:
            binary_data = file.read()

        insert_query = "INSERT INTO documents (name, content) VALUES (%s, %s)"
        cursor.execute(insert_query, (name, binary_data))
        connection.commit()

        print("Document inserted successfully")

    except Error as e:
        print(f"Error: {e}")

    finally:
        if connection.is_connected():
            cursor.close()
            connection.close()

# 示例调用
insert_document('example.docx', '/path/to/example.docx')

def retrieve_document(document_id):
    try:
        connection = mysql.connector.connect(host='localhost',
                                             database='your_database',
                                             user='your_user',
                                             password='your_password')

        cursor = connection.cursor()

        select_query = "SELECT name, content FROM documents WHERE id = %s"
        cursor.execute(select_query, (document_id,))
        record = cursor.fetchone()

        if record:
            name, content = record
            with open(f'retrieved_{name}', 'wb') as file:
                file.write(content)
            print(f"Document retrieved successfully: retrieved_{name}")
        else:
            print("Document not found")

    except Error as e:
        print(f"Error: {e}")

    finally:
        if connection.is_connected():
            cursor.close()
            connection.close()

# 示例调用
retrieve_document(1)