import mariadb
 
config = {
    'host': 'localhost',
    'user': 'feherbt',
    'password': 'titok',
}
 
conn = mariadb.connect(**config, database='feherbt')
cur = conn.cursor()

sql = """
insert into employees
(name, city, salary)
values
(?, ?, ?)
"""
values = ('Csirke Borbála', 'Miskolc', 5250000)
cur.execute(sql, values)

lastrowid = cur.lastrowid
print('Utoljára beszúrt: ', cur.lastrowid)
print('Érintett rekordok száma: ', cur.rowcount)

sql = """
update employees
set
name='Tengeri Béla' where id = {lastrowid}
"""

conn.commit() 
conn.close()