import mysql.connector
 
config = {
  'host': 'localhost',
  'user': 'feherbt',
  'passwd':'titok'
}

conn = mysql.connector.connect(**config, database='feherbt')

cur = conn.cursor()
sql = """
insert into employees
(name, city, salary)
values
(%s, %s, %s)
"""
values = ("Perec Dénes", "Szeged", 2800400)
cur.execute(sql, values)
conn.commit()
conn.close()

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