import mysql.connector
 
# Connect to MySQL server
db = mysql.connector.connect(
    host="localhost",
    user="your_username",
    password="your_password"
)
 
cursor = db.cursor()
 
# Create a new database
cursor.execute("CREATE DATABASE mydatabase")
 
# Use the new database
cursor.execute("USE mydatabase")
 
# Create a new table
cursor.execute("CREATE TABLE students (id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(255), age INT)")
 
# Insert records
query = "INSERT INTO students (name, age) VALUES (%s, %s)"
values = [
    ("John", 20),
    ("Amy", 22),
    ("Mark", 19)
]
cursor.executemany(query, values)
db.commit()
 
# Retrieve all records
cursor.execute("SELECT * FROM students")
records = cursor.fetchall()
for record in records:
    print(record)
 
# Update a record
cursor.execute("UPDATE students SET age = 21 WHERE name = 'John'")
db.commit()
 
# Retrieve and print the updated record
cursor.execute("SELECT * FROM students WHERE name = 'John'")
record = cursor.fetchone()
print(record)
 
# Delete a record
cursor.execute("DELETE FROM students WHERE name = 'Mark'")
db.commit()
 
# Retrieve all records again
cursor.execute("SELECT * FROM students")
records = cursor.fetchall()
for record in records:
    print(record)
 

aW1wb3J0IG15c3FsLmNvbm5lY3RvcgoKIyBDb25uZWN0IHRvIE15U1FMIHNlcnZlcgpkYiA9IG15c3FsLmNvbm5lY3Rvci5jb25uZWN0KAogICAgaG9zdD0ibG9jYWxob3N0IiwKICAgIHVzZXI9InlvdXJfdXNlcm5hbWUiLAogICAgcGFzc3dvcmQ9InlvdXJfcGFzc3dvcmQiCikKCmN1cnNvciA9IGRiLmN1cnNvcigpCgojIENyZWF0ZSBhIG5ldyBkYXRhYmFzZQpjdXJzb3IuZXhlY3V0ZSgiQ1JFQVRFIERBVEFCQVNFIG15ZGF0YWJhc2UiKQoKIyBVc2UgdGhlIG5ldyBkYXRhYmFzZQpjdXJzb3IuZXhlY3V0ZSgiVVNFIG15ZGF0YWJhc2UiKQoKIyBDcmVhdGUgYSBuZXcgdGFibGUKY3Vyc29yLmV4ZWN1dGUoIkNSRUFURSBUQUJMRSBzdHVkZW50cyAoaWQgSU5UIEFVVE9fSU5DUkVNRU5UIFBSSU1BUlkgS0VZLCBuYW1lIFZBUkNIQVIoMjU1KSwgYWdlIElOVCkiKQoKIyBJbnNlcnQgcmVjb3JkcwpxdWVyeSA9ICJJTlNFUlQgSU5UTyBzdHVkZW50cyAobmFtZSwgYWdlKSBWQUxVRVMgKCVzLCAlcykiCnZhbHVlcyA9IFsKICAgICgiSm9obiIsIDIwKSwKICAgICgiQW15IiwgMjIpLAogICAgKCJNYXJrIiwgMTkpCl0KY3Vyc29yLmV4ZWN1dGVtYW55KHF1ZXJ5LCB2YWx1ZXMpCmRiLmNvbW1pdCgpCgojIFJldHJpZXZlIGFsbCByZWNvcmRzCmN1cnNvci5leGVjdXRlKCJTRUxFQ1QgKiBGUk9NIHN0dWRlbnRzIikKcmVjb3JkcyA9IGN1cnNvci5mZXRjaGFsbCgpCmZvciByZWNvcmQgaW4gcmVjb3JkczoKICAgIHByaW50KHJlY29yZCkKCiMgVXBkYXRlIGEgcmVjb3JkCmN1cnNvci5leGVjdXRlKCJVUERBVEUgc3R1ZGVudHMgU0VUIGFnZSA9IDIxIFdIRVJFIG5hbWUgPSAnSm9obiciKQpkYi5jb21taXQoKQoKIyBSZXRyaWV2ZSBhbmQgcHJpbnQgdGhlIHVwZGF0ZWQgcmVjb3JkCmN1cnNvci5leGVjdXRlKCJTRUxFQ1QgKiBGUk9NIHN0dWRlbnRzIFdIRVJFIG5hbWUgPSAnSm9obiciKQpyZWNvcmQgPSBjdXJzb3IuZmV0Y2hvbmUoKQpwcmludChyZWNvcmQpCgojIERlbGV0ZSBhIHJlY29yZApjdXJzb3IuZXhlY3V0ZSgiREVMRVRFIEZST00gc3R1ZGVudHMgV0hFUkUgbmFtZSA9ICdNYXJrJyIpCmRiLmNvbW1pdCgpCgojIFJldHJpZXZlIGFsbCByZWNvcmRzIGFnYWluCmN1cnNvci5leGVjdXRlKCJTRUxFQ1QgKiBGUk9NIHN0dWRlbnRzIikKcmVjb3JkcyA9IGN1cnNvci5mZXRjaGFsbCgpCmZvciByZWNvcmQgaW4gcmVjb3JkczoKICAgIHByaW50KHJlY29yZCkK