MySQL with Python: A Practical Guide

import mysql.connector

try:
    conn = mysql.connector.connect(
        host='localhost',
        user='root',
        password='your_password',
        database='testdb'
    )
    print('Connection successful')
except mysql.connector.Error as err:
    print(f'Error: {err}')
finally:
    if conn.is_connected():
        conn.close()

import mysql.connector

conn = mysql.connector.connect(host='localhost', user='root', password='your_password', database='testdb')
cursor = conn.cursor()

insert_query = "INSERT INTO employees (name, age, department) VALUES (%s, %s, %s)"
values = ('Alice', 30, 'HR')
cursor.execute(insert_query, values)
conn.commit()

print(f'{cursor.rowcount} record inserted.')
cursor.close()
conn.close()

import mysql.connector

conn = mysql.connector.connect(host='localhost', user='root', password='your_password', database='testdb')
cursor = conn.cursor()

select_query = "SELECT * FROM employees"
cursor.execute(select_query)

for row in cursor.fetchall():
    print(row)

cursor.close()
conn.close()