怎么将excel表格导入mysql数据库

import pandas as pd
import mysql.connector

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

# 将DataFrame保存为CSV文件
csv_file = 'data.csv'
df.to_csv(csv_file, index=False)

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

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

# 导入CSV文件到MySQL
load_data_query = """
LOAD DATA INFILE '/path/to/data.csv'
INTO TABLE data_table
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 ROWS;
"""
cursor.execute(load_data_query)

# 提交更改并关闭连接
db.commit()
cursor.close()
db.close()