如何使用Python在MySQL中以列的形式插入列表？

pip install mysql-connector-python

import mysql.connector

cnx = mysql.connector.connect(user='your_username', password='your_password',
                              host='your_host', database='your_database')

cursor = cnx.cursor()

create_table_query = "CREATE TABLE IF NOT EXISTS your_table (column1 VARCHAR(255), column2 VARCHAR(255), ...)"
cursor.execute(create_table_query)

data = [('value1', 'value2', ...), ('value1', 'value2', ...), ...]

insert_query = "INSERT INTO your_table (column1, column2, ...) VALUES (%s, %s, ...)"

cursor.executemany(insert_query, data)
cnx.commit()

cursor.close()
cnx.close()