Connecting Python to MySQL

import mysql.connector

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

cursor = connection.cursor()

Create Table

cursor.execute("""
CREATE TABLE IF NOT EXISTS users (
 id INT AUTO_INCREMENT PRIMARY KEY,
 name VARCHAR(100),
 email VARCHAR(100)
)
""")
connection.commit()

Insert Data

cursor.execute(
 "INSERT INTO users (name,email) VALUES (%s,%s)",
 ("Alice","alice@example.com")
)
connection.commit()

Last Inserted ID

user_id = cursor.lastrowid

Read Data

cursor.execute("SELECT * FROM users")
for row in cursor.fetchall():
 print(row)

Update

cursor.execute(
 "UPDATE users SET email=%s WHERE id=%s",
 ("new@email.com",1)
)
connection.commit()

Delete

cursor.execute(
 "DELETE FROM users WHERE id=%s",
 (1,)
)
connection.commit()