往 mysql上传文件

CREATE TABLE files (
    id INT AUTO_INCREMENT PRIMARY KEY,
    filename VARCHAR(255) NOT NULL,
    file_content LONGBLOB NOT NULL
);

Hello, World!

import mysql.connector

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

cursor = db.cursor()

# 读取文件内容
with open('example.txt', 'rb') as file:
    file_content = file.read()

# 插入文件内容到数据库
sql = "INSERT INTO files (filename, file_content) VALUES (%s, %s)"
values = ("example.txt", file_content)
cursor.execute(sql, values)

# 提交事务
db.commit()

print("文件上传成功！")

# 关闭连接
cursor.close()
db.close()

with open('example.txt', 'rb') as file:
    file_content = file.read()
    if not file_content:
        print("文件内容为空")

try:
    cursor.execute(sql, values)
    db.commit()
    print("文件上传成功！")
except mysql.connector.Error as err:
    print(f"数据库错误: {err}")
finally:
    cursor.close()
    db.close()