01_executemany.py

import mysql.connector

conn = None
cursor = None

try:
    conn = mysql.connector.connect(
        host="localhost",
        user="root",
        password="YOUR_PASSWORD",
        database="test"
    )
    print("Connected to MySQL server")

    cursor = conn.cursor()
    query = "INSERT INTO demo (id, name, salary) VALUES (%s, %s, %s)"
    data = [
        (2, "Abhi", 45000),
        (3, "Ravi", 60000),
        (4, "Pooja", 55000)
    ]

    cursor.executemany(query, data)
    conn.commit()
    print(cursor.rowcount, "records inserted successfully into demo table")

except Exception as err:
    print(f"Error: {err}")

finally:
    print("Inside finally block")
    if cursor is not None:
        cursor.close()
    if conn is not None and conn.is_connected():
        conn.close()
        print("Connection closed")