如何将flappy bird (在python3.9上用pygame制作)的分数保存到sql数据库中

CREATE TABLE scores (
    id INT AUTO_INCREMENT PRIMARY KEY,
    player_name VARCHAR(255),
    score INT
);

pip install mysql-connector-python

import mysql.connector

# 建立数据库连接
cnx = mysql.connector.connect(
    host="数据库主机地址",
    user="数据库用户名",
    password="数据库密码",
    database="数据库名"
)

# 获取游戏分数和玩家信息
score = 100  # 假设分数为100
player_name = "玩家1"  # 假设玩家名为"玩家1"

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

# 执行插入数据的SQL语句
insert_query = "INSERT INTO scores (player_name, score) VALUES (%s, %s)"
data = (player_name, score)
cursor.execute(insert_query, data)

# 提交事务
cnx.commit()

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

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

# 执行查询数据的SQL语句
select_query = "SELECT player_name, score FROM scores ORDER BY score DESC LIMIT 10"
cursor.execute(select_query)

# 获取查询结果
results = cursor.fetchall()

# 打印查询结果
for player_name, score in results:
    print(f"玩家：{player_name}，分数：{score}")

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