批量查询mysql数据库

import mysql.connector

# 连接到MySQL数据库
mydb = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  password="yourpassword",
  database="yourdatabase"
)

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

# 批量SELECT查询示例
sql = "SELECT * FROM customers WHERE country IN (%s)"
val = ("USA", "Canada", "UK")
mycursor.execute(sql, val)

myresult = mycursor.fetchall()
for x in myresult:
  print(x)

try:
  mydb.start_transaction()
  sql = "INSERT INTO customers (name, address) VALUES (%s, %s)"
  val = [
    ('John', 'Highway 21'),
    ('Peter', 'Lowstreet 4'),
    ('Amy', 'Apple st 652')
  ]
  mycursor.executemany(sql, val)
  mydb.commit()
except mysql.connector.Error as error:
  print("Failed to insert record into MySQL table {}".format(error))
  mydb.rollback()