使用Python将CSV数据加载到MySQL中，创建表并添加记录

import csv
import pymysql

conn = pymysql.connect(host='localhost', user='username', password='password', database='database_name')

cursor = conn.cursor()

create_table_query = "CREATE TABLE table_name (column1 datatype, column2 datatype, ...)"
cursor.execute(create_table_query)

with open('data.csv', 'r') as file:
    csv_data = csv.reader(file)
    next(csv_data)  # 跳过CSV文件的标题行
    for row in csv_data:
        # 将每一行数据插入到MySQL表中
        insert_query = "INSERT INTO table_name (column1, column2, ...) VALUES (%s, %s, ...)"
        cursor.execute(insert_query, row)

conn.commit()
conn.close()