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
('Tekerős Ferenc', 'Hatvan', 2877000)
"""
cur.execute(sql)
conn.commit()
conn.close()

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