如何使用python将csv文件中的数据写入MySQL数据库？

import pandas as pd
import pymysql

connection = pymysql.connect(
    host='localhost',
    user='root',
    password='your_password',
    database='your_database'
)

data = pd.read_csv('your_csv_file.csv')

cursor = connection.cursor()

create_table_query = '''
    CREATE TABLE IF NOT EXISTS your_table (
        column1 DATATYPE,
        column2 DATATYPE,
        ...
    )
'''
cursor.execute(create_table_query)

insert_query = '''
    INSERT INTO your_table (column1, column2, ...)
    VALUES (%s, %s, ...)
'''
values = [tuple(row) for row in data.values]
cursor.executemany(insert_query, values)

connection.commit()
connection.close()

import pandas as pd
import pymysql

# 建立与数据库的连接
connection = pymysql.connect(
    host='localhost',
    user='root',
    password='your_password',
    database='your_database'
)

# 读取CSV文件数据
data = pd.read_csv('your_csv_file.csv')

# 创建游标对象
cursor = connection.cursor()

# 创建表（可选）
create_table_query = '''
    CREATE TABLE IF NOT EXISTS your_table (
        column1 DATATYPE,
        column2 DATATYPE,
        ...
    )
'''
cursor.execute(create_table_query)

# 将数据插入表中
insert_query = '''
    INSERT INTO your_table (column1, column2, ...)
    VALUES (%s, %s, ...)
'''
values = [tuple(row) for row in data.values]
cursor.executemany(insert_query, values)

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