Python ile MySQL'e bilgi gönderme

import mysql.connector
from datetime import datetime


connection = mysql.connector.connect(
    host="localhost",
    user="root",
    password="abc123"
)


cursor = connection.cursor()
cursor.execute()





mycursor = connection.cursor()


students_data = [
    (200531, "isim", "soyisim", datetime(2000, 1, 1), "E"),
    (200531, "isim", "soyisim", datetime(2000, 1, 1), "E"),
    (200531, "isim", "soyisim", datetime(2000, 1, 1), "E"),
    (200531, "isim", "soyisim", datetime(2000, 1, 1), "E"),
    (200531, "isim", "soyisim", datetime(2000, 1, 1), "E"),
    (200531, "isim", "soyisim", datetime(2000, 1, 1), "E"),
]





sql = "INSERT INTO School.db(StudentNumber, Name, Surname, Birthday, Gender) VALUES (%s, %s, %s, %s, %s)"


mycursor.executemany(sql, students_data)

connection.commit()


connection.close()