尝试将表名中带有"-“的MySQL表获取到Pandas dataframe时出现编程错误(SQL语法)

import pandas as pd
import pymysql

# 连接到MySQL数据库
conn = pymysql.connect(host='localhost', user='root', password='password', db='database_name')

# 创建一个游标对象
cursor = conn.cursor()

# 使用反引号括起带有"-"的表名
table_name = '`table-name`'

# 执行SQL查询语句
query = f"SELECT * FROM {table_name}"
cursor.execute(query)

# 获取查询结果并转换为Pandas dataframe
data = cursor.fetchall()
df = pd.DataFrame(data)

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

# 打印Pandas dataframe
print(df)