视频怎么存mysql数据库

CREATE TABLE videos (
    id INT AUTO_INCREMENT PRIMARY KEY,
    title VARCHAR(255),
    video_data LONGBLOB
);

import mysql.connector

db = mysql.connector.connect(
    host="localhost",
    user="yourusername",
    password="yourpassword",
    database="yourdatabase"
)

cursor = db.cursor()

# 假设video_file_path是视频文件的路径
with open('video_file_path', 'rb') as video_file:
    video_data = video_file.read()

sql = "INSERT INTO videos (title, video_data) VALUES (%s, %s)"
values = ("Sample Video", video_data)

cursor.execute(sql, values)
db.commit()

import mysql.connector

db = mysql.connector.connect(
    host="localhost",
    user="yourusername",
    password="yourpassword",
    database="yourdatabase"
)

cursor = db.cursor()

sql = "SELECT video_data FROM videos WHERE id = %s"
cursor.execute(sql, (1,))

result = cursor.fetchone()
video_data = result[0]

with open('retrieved_video.mp4', 'wb') as video_file:
    video_file.write(video_data)