使用python将3个列表插入mysql

import mysql.connector

mydb = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  password="yourpassword",
  database="yourdatabase"
)

cursor = mydb.cursor()

list1 = [1, 2, 3]
list2 = ['a', 'b', 'c']
list3 = [True, False, True]

sql = "INSERT INTO yourtable (column1, column2, column3) VALUES (%s, %s, %s)"

for i in range(len(list1)):
  val = (list1[i], list2[i], list3[i])
  cursor.execute(sql, val)

mydb.commit()

cursor.close()
mydb.close()