使用python3将csv文件导入mysql数据库

pip install pandas
pip install mysql-connector-python

import pandas as pd
import mysql.connector

# 读取CSV文件
data = pd.read_csv('your_file.csv')

# 建立与MySQL数据库的连接
conn = mysql.connector.connect(
    host='your_host',
    user='your_user',
    password='your_password',
    database='your_database'
)

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

# 创建表格
create_table_query = '''
CREATE TABLE IF NOT EXISTS your_table (
    column1 datatype,
    column2 datatype,
    ...
)
'''
cursor.execute(create_table_query)

# 将数据插入表格
for row in data.itertuples(index=False):
    insert_query = '''
    INSERT INTO your_table (column1, column2, ...)
    VALUES (%s, %s, ...)
    '''
    cursor.execute(insert_query, row)

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