怎么将歌曲存入mysql数据库

CREATE TABLE songs (
    id INT PRIMARY KEY AUTO_INCREMENT,
    title VARCHAR(255),
    artist VARCHAR(255),
    genre VARCHAR(255),
    file_path VARCHAR(255)
);

import mysql.connector

# 连接到MySQL数据库
db = mysql.connector.connect(
    host="localhost",
    user="your_username",
    password="your_password",
    database="your_database"
)

# 创建游标
cursor = db.cursor()

# 插入歌曲数据
sql = "INSERT INTO songs (title, artist, genre, file_path) VALUES (%s, %s, %s, %s)"
values = ("Song Title", "Artist Name", "Pop", "/path/to/song.mp3")
cursor.execute(sql, values)

# 提交事务
db.commit()

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