I have a MySQL table called empleados
, I'm in the option modificar
, this is the final code of the cycle modificar
:
sql="update Empleados set numdocEmp='"+numdocEmp+"', NombreEmp= '"+nombreEmp+"', salariobasico= '"+salbasicEmp+"', \ Fechaingreso= '"+fechaingEmp+"', NombreEPS= '"+nombre_eps+"', NombreAFP= '"+nombre_afp+"' where IdEmpleado="+idEmpleados
cursor = con.cursor()
cursor.execute(sql)
con.commit()
con.close()
All changes are accepted but the following error is displayed:
_mysql_exceptions.OperationalError: (1054, "Unknown column 'EmployeeID' in 'where clause'")
idEmpleado
is the primary key of my table. I can not find the cause, I appreciate the help.