MySQL with Python

pip install pymysql

import pymysql

# Connect
conn = pymysql.connect(
    host="localhost",
    user="root",
    password="",
    database="school",
    charset="utf8mb4"
)
cursor = conn.cursor(pymysql.cursors.DictCursor)

# INSERT
cursor.execute(
    "INSERT INTO students (name, marks) VALUES (%s, %s)",
    ("Gagan", 95)
)
conn.commit()

# SELECT
cursor.execute("SELECT * FROM students ORDER BY marks DESC")
rows = cursor.fetchall()
for row in rows:
    print(f"{row['name']}: {row['marks']}")

# Close
cursor.close()
conn.close()