将数据框单元格值(列表)插入到mysql多列Python

pip install pandas
pip install pymysql

import pandas as pd
import pymysql

# 创建MySQL连接
conn = pymysql.connect(host='localhost', user='your_username', password='your_password', database='your_database')

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

# 将数据框单元格值(列表)插入到MySQL多列
for index, row in df.iterrows():
    col1 = row['列1']
    col2 = row['列2']
    col3 = row['列3']
    # 其他列以此类推

    # 构建SQL插入语句
    sql = "INSERT INTO your_table (列1, 列2, 列3) VALUES (%s, %s, %s)"  # 根据实际表名和列名修改

    # 执行SQL语句
    cursor.execute(sql, (col1, col2, col3))  # 根据实际列数修改

# 提交事务
conn.commit()

# 关闭游标和连接
cursor.close()
conn.close()