mariadb_connector_python_quickstart_insert_and_select.py

1# Module Imports
2import mariadb
3import sys
4
5# Instantiate Connection
6try:
7    conn = mariadb.connect(
8        user="db_user",
9        password="db_user_password",
10        host="127.0.0.1",
11        port=3306,
12        database="employees"
13    )
14except mariadb.Error as e:
15    print(f"Error connecting to MariaDB Platform: {e}")
16    sys.exit(1)
17
18# Get Cursor
19cur = conn.cursor()
20
21# Insert some data
22try:
23    cur.execute(
24        "INSERT INTO employees (first_name,last_name) VALUES (?, ?)", 
25        ("Maria","DB"))
26except mariadb.Error as e:
27    print(f"Error: {e}")
28
29conn.commit()
30print(f"Last Inserted ID: {cur.lastrowid}")
31
32# Retrieve Data
33cur.execute("SELECT first_name, last_name FROM employees")
34
35for (first_name, last_name) in cur:
36    print(f"First Name: {first_name}, Last Name: {last_name}")
37
38# Close Connection
39conn.close()