mysql数据库中怎么存文件

CREATE TABLE files (
  id INT AUTO_INCREMENT PRIMARY KEY,
  filename VARCHAR(255),
  filedata LONGBLOB,
  filetype VARCHAR(255)
);

import mysql.connector

# 连接到MySQL数据库
cnx = mysql.connector.connect(user='username', password='password', host='localhost', database='dbname')

# 创建游标对象
cursor = cnx.cursor()

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

# 准备插入文件数据的SQL语句
insert_query = "INSERT INTO files (filename, filedata, filetype) VALUES (%s, %s, %s)"

# 执行插入操作
cursor.execute(insert_query, ('file.txt', filedata, 'text/plain'))

# 提交事务
cnx.commit()

# 关闭游标和数据库连接
cursor.close()
cnx.close()

import mysql.connector

# 连接到MySQL数据库
cnx = mysql.connector.connect(user='username', password='password', host='localhost', database='dbname')

# 创建游标对象
cursor = cnx.cursor()

# 准备查询文件数据的SQL语句
select_query = "SELECT filename, filedata FROM files WHERE id = %s"

# 执行查询操作
cursor.execute(select_query, (1,))

# 获取查询结果
result = cursor.fetchone()

# 将文件数据保存为文件
with open(result[0], 'wb') as file:
    file.write(result[1])

# 关闭游标和数据库连接
cursor.close()
cnx.close()