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 = [
    ('Csevegő Emese', 'Miskolc', 2250000),
    ('Rakica Katalin', 'Szolnok', 3250000),
    ('Libi Melinda', 'Miskolc', 4950000),
]
cur.executemany(sql, values)

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

conn.commit() 
conn.close()