如何把excel导入mysql

import pandas as pd
import mysql.connector

# 读取Excel文件
excel_file = 'path_to_your_excel_file.xlsx'
df = pd.read_excel(excel_file)

# 连接到MySQL数据库
mydb = mysql.connector.connect(
  host="your_host",
  user="your_user",
  password="your_password",
  database="your_database"
)

mycursor = mydb.cursor()

# 创建表（假设表名为your_table）
create_table_query = """
CREATE TABLE IF NOT EXISTS your_table (
    id INT AUTO_INCREMENT PRIMARY KEY,
    column1 VARCHAR(255),
    column2 INT,
    column3 DATE
)
"""
mycursor.execute(create_table_query)

# 将DataFrame数据插入MySQL表
for index, row in df.iterrows():
    insert_query = f"INSERT INTO your_table (column1, column2, column3) VALUES ('{row['column1']}', {row['column2']}, '{row['column3']}')"
    mycursor.execute(insert_query)

# 提交更改
mydb.commit()

# 关闭连接
mycursor.close()
mydb.close()