怎么把xlsx导入mysql数据库

import openpyxl
import pymysql

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

# 打开xlsx文件并选择工作表
workbook = openpyxl.load_workbook('data.xlsx')
sheet = workbook['Sheet1']

# 创建表（如果不存在）
create_table_query = """
CREATE TABLE IF NOT EXISTS table_name (
    column1 datatype,
    column2 datatype,
    ...
)
"""
cursor.execute(create_table_query)

# 读取数据并插入到数据库表中
for row in sheet.iter_rows(min_row=2, values_only=True):
    insert_query = "INSERT INTO table_name (column1, column2, ...) VALUES (%s, %s, ...)"
    cursor.execute(insert_query, row)

# 提交事务
conn.commit()

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