mysql存放声音文件

CREATE TABLE sound_files (
    id INT AUTO_INCREMENT PRIMARY KEY,
    file_name VARCHAR(255) NOT NULL,
    file_path VARCHAR(255) NOT NULL,
    upload_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

import mysql.connector

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

cursor = db.cursor()

# 插入声音文件信息
file_name = "example.mp3"
file_path = "/path/to/example.mp3"
sql = "INSERT INTO sound_files (file_name, file_path) VALUES (%s, %s)"
cursor.execute(sql, (file_name, file_path))

db.commit()
print("声音文件信息已插入数据库")