我需要一个想法有关保存一个列表discord.py机器人上的播放器的问题

CREATE TABLE players (
    id INT PRIMARY KEY AUTO_INCREMENT,
    song_name VARCHAR(255),
    artist VARCHAR(255),
    duration INT
);

import mysql.connector

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

# 获取数据库游标
cursor = db.cursor()

# 插入新播放器信息
song_name = "Song 1"
artist = "Artist 1"
duration = 180

sql = "INSERT INTO players (song_name, artist, duration) VALUES (%s, %s, %s)"
values = (song_name, artist, duration)

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

print("播放器已添加到列表")

# 从数据库中检索播放器列表
cursor.execute("SELECT * FROM players")
results = cursor.fetchall()

# 显示播放器列表
for player in results:
    print(player)

# 关闭数据库连接
cursor.close()
db.close()